Sort (cost=226042.94..226052.48 rows=3817 width=17) (actual time=274.194..274.345 rows=4088 loops=1)
Output: greathistory."domainName", ((SubPlan 1)), ((SubPlan 2)), ((SubPlan 3)), ((SubPlan 4)), ((SubPlan 5)), ((SubPlan 6)), ((SubPlan 7))
Sort Key: greathistory."domainName""
Sort Method: quicksort Memory: 330kB"
-> HashAggregate (cost=3588.90..225815.86 rows=3817 width=17) (actual time=34.630..251.572 rows=4088 loops=1)
Output: greathistory."domainName", (SubPlan 1), (SubPlan 2), (SubPlan 3), (SubPlan 4), (SubPlan 5), (SubPlan 6), (SubPlan 7)
-> Seq Scan on history greathistory (cost=0.00..3562.81 rows=10435 width=17) (actual time=14.664..31.224 rows=10751 loops=1)
Output: greathistory."historyID", greathistory."domainName", greathistory."historyTimestamp", greathistory."historyType", greathistory."historyTypeValue", greathistory."historyServer"
Filter: (("domainName")::text ~~ 'w%'::text)
SubPlan 1
-> Limit (cost=0.00..8.32 rows=1 width=16) (actual time=0.012..0.012 rows=1 loops=4088)
Output: public.history."historyTypeValue"
-> Index Scan Backward using history_history_idx on history (cost=0.00..8.32 rows=1 width=16) (actual time=0.011..0.011 rows=1 loops=4088)
Output: public.history."historyTypeValue"
Index Cond: (("historyType" = 14) AND (("domainName")::text = ($0)::text))
SubPlan 2
-> Limit (cost=0.00..8.32 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=4088)
Output: public.history."historyTypeValue"
-> Index Scan Backward using history_history_idx on history (cost=0.00..8.32 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=4088)
Output: public.history."historyTypeValue"
Index Cond: (("historyType" = 3) AND (("domainName")::text = ($0)::text))
SubPlan 3
-> Limit (cost=0.00..8.32 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=4088)
Output: public.history."historyTypeValue"
-> Index Scan Backward using history_history_idx on history (cost=0.00..8.32 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=4088)
Output: public.history."historyTypeValue"
Index Cond: (("historyType" = 12) AND (("domainName")::text = ($0)::text))
SubPlan 4
-> Limit (cost=0.00..8.32 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=4088)
Output: public.history."historyTypeValue"
-> Index Scan Backward using history_history_idx on history (cost=0.00..8.32 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=4088)
Output: public.history."historyTypeValue"
Index Cond: (("historyType" = 13) AND (("domainName")::text = ($0)::text))
SubPlan 5
-> Limit (cost=0.00..8.32 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=4088)
Output: public.history."historyTypeValue"
-> Index Scan Backward using history_history_idx on history (cost=0.00..8.32 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=4088)
Output: public.history."historyTypeValue"
Index Cond: (("historyType" = 30) AND (("domainName")::text = ($0)::text))
SubPlan 6
-> Limit (cost=0.00..8.32 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=4088)
Output: public.history."historyTypeValue"
-> Index Scan Backward using history_history_idx on history (cost=0.00..8.32 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=4088)
Output: public.history."historyTypeValue"
Index Cond: (("historyType" = 22) AND (("domainName")::text = ($0)::text))"
SubPlan 7
-> Limit (cost=0.00..8.32 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=4088)"
Output: public.history."historyTypeValue"
-> Index Scan Backward using history_history_idx on history (cost=0.00..8.32 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=4088)
Output: public.history."historyTypeValue"
Index Cond: (("historyType" = 10) AND (("domainName")::text = ($0)::text))
Total runtime: 274.817 ms
Lesezeichen