Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq

#	exclusive	inclusive	rows x	rows	loops	node
1.	0.026	1,724.706	↑ 1.0	10	1	→ Limit (cost=34,159.40..34,159.43 rows=10 width=1,332) (actual time=1,724.672..1,724.706 rows=10 loops=1) Total runtime: 1724.952 ms
2.	107.624	1,724.680	↑ 4,454.4	10	1	→ Sort (cost=34,159.40..34,270.76 rows=44,544 width=1,332) (actual time=1,724.668..1,724.680 rows=10 loops=1) Sort Key: c.pulldate, c.pubdate Sort Method: top-N heapsort Memory: 45kB
3.	84.372	1,617.056	↑ 1.9	23,284	1	→ Hash Join (cost=5,143.80..33,196.82 rows=44,544 width=1,332) (actual time=623.709..1,617.056 rows=23,284 loops=1) Hash Cond: (c.d_id = t6.id)
4.	69.986	1,531.408	↑ 1.9	23,284	1	→ Nested Loop (cost=5,121.50..32,562.05 rows=44,544 width=1,154) (actual time=622.418..1,531.408 rows=23,284 loops=1)
5.	0.014	0.014	↑ 1.0	1	1	→ Seq Scan on e (cost=0.00..1.19 rows=1 width=157) (actual time=0.008..0.014 rows=1 loops=1) Filter: (id = 2)
6.	80.214	1,461.408	↑ 1.9	23,284	1	→ Hash Join (cost=5,121.50..32,115.42 rows=44,544 width=997) (actual time=622.399..1,461.408 rows=23,284 loops=1) Hash Cond: (b.d_id = d.id)
7.	349.694	1,379.967	↑ 1.9	23,284	1	→ Hash Join (cost=5,099.21..31,480.65 rows=44,544 width=819) (actual time=621.155..1,379.967 rows=23,284 loops=1) Hash Cond: (c.id = a.c_id)
8.	409.150	409.150	↓ 1.1	165,113	1	→ Seq Scan on c (cost=0.00..22,036.12 rows=155,995 width=763) (actual time=0.005..409.150 rows=165,113 loops=1) Filter: (pulldate >= '1994-04-03 06:00:00+00'::timestamp with time zone)
9.	46.992	621.123	↑ 1.9	23,284	1	→ Hash (cost=4,542.36..4,542.36 rows=44,548 width=56) (actual time=621.123..621.123 rows=23,284 loops=1) Buckets: 8192 Batches: 1 Memory Usage: 2101kB
10.	293.251	574.131	↑ 1.9	23,284	1	→ Hash Join (cost=13.91..4,542.36 rows=44,548 width=56) (actual time=0.461..574.131 rows=23,284 loops=1) Hash Cond: (a.b_id = b.id)
11.	280.437	280.437	↓ 1.0	172,527	1	→ Seq Scan on a (cost=0.00..3,436.59 rows=172,368 width=17) (actual time=0.009..280.437 rows=172,527 loops=1) Filter: (state < 2)
12.	0.183	0.443	↑ 1.0	130	1	→ Hash (cost=12.29..12.29 rows=130 width=39) (actual time=0.443..0.443 rows=130 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 10kB
13.	0.260	0.260	↑ 1.0	130	1	→ Seq Scan on b (cost=0.00..12.29 rows=130 width=39) (actual time=0.006..0.260 rows=130 loops=1) Filter: (count AND (e_id = 2))
14.	0.675	1.227	↑ 1.0	413	1	→ Hash (cost=17.13..17.13 rows=413 width=178) (actual time=1.227..1.227 rows=413 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 87kB
15.	0.552	0.552	↑ 1.0	413	1	→ Seq Scan on d (cost=0.00..17.13 rows=413 width=178) (actual time=0.003..0.552 rows=413 loops=1)
16.	0.679	1.276	↑ 1.0	413	1	→ Hash (cost=17.13..17.13 rows=413 width=178) (actual time=1.276..1.276 rows=413 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 87kB
17.	0.597	0.597	↑ 1.0	413	1	→ Seq Scan on d t6 (cost=0.00..17.13 rows=413 width=178) (actual time=0.008..0.597 rows=413 loops=1)

Limit  (cost=34159.40..34159.43 rows=10 width=1332) (actual time=1724.672..1724.706 rows=10 loops=1)
   ->  Sort  (cost=34159.40..34270.76 rows=44544 width=1332) (actual time=1724.668..1724.680 rows=10 loops=1)
         Sort Key: c.pulldate, c.pubdate
         Sort Method: top-N heapsort  Memory: 45kB
         ->  Hash Join  (cost=5143.80..33196.82 rows=44544 width=1332) (actual time=623.709..1617.056 rows=23284 loops=1)
               Hash Cond: (c.d_id = t6.id)
               ->  Nested Loop  (cost=5121.50..32562.05 rows=44544 width=1154) (actual time=622.418..1531.408 rows=23284 loops=1)
                     ->  Seq Scan on e  (cost=0.00..1.19 rows=1 width=157) (actual time=0.008..0.014 rows=1 loops=1)
                           Filter: (id = 2)
                     ->  Hash Join  (cost=5121.50..32115.42 rows=44544 width=997) (actual time=622.399..1461.408 rows=23284 loops=1)
                           Hash Cond: (b.d_id = d.id)
                           ->  Hash Join  (cost=5099.21..31480.65 rows=44544 width=819) (actual time=621.155..1379.967 rows=23284 loops=1)
                                 Hash Cond: (c.id = a.c_id)
                                 ->  Seq Scan on c  (cost=0.00..22036.12 rows=155995 width=763) (actual time=0.005..409.150 rows=165113 loops=1)
                                       Filter: (pulldate >= '1994-04-03 06:00:00+00'::timestamp with time zone)
                                 ->  Hash  (cost=4542.36..4542.36 rows=44548 width=56) (actual time=621.123..621.123 rows=23284 loops=1)
                                       Buckets: 8192  Batches: 1  Memory Usage: 2101kB
                                       ->  Hash Join  (cost=13.91..4542.36 rows=44548 width=56) (actual time=0.461..574.131 rows=23284 loops=1)
                                             Hash Cond: (a.b_id = b.id)
                                             ->  Seq Scan on a  (cost=0.00..3436.59 rows=172368 width=17) (actual time=0.009..280.437 rows=172527 loops=1)
                                                   Filter: (state < 2)
                                             ->  Hash  (cost=12.29..12.29 rows=130 width=39) (actual time=0.443..0.443 rows=130 loops=1)
                                                   Buckets: 1024  Batches: 1  Memory Usage: 10kB
                                                   ->  Seq Scan on b  (cost=0.00..12.29 rows=130 width=39) (actual time=0.006..0.260 rows=130 loops=1)
                                                         Filter: (count AND (e_id = 2))
                           ->  Hash  (cost=17.13..17.13 rows=413 width=178) (actual time=1.227..1.227 rows=413 loops=1)
                                 Buckets: 1024  Batches: 1  Memory Usage: 87kB
                                 ->  Seq Scan on d  (cost=0.00..17.13 rows=413 width=178) (actual time=0.003..0.552 rows=413 loops=1)
               ->  Hash  (cost=17.13..17.13 rows=413 width=178) (actual time=1.276..1.276 rows=413 loops=1)
                     Buckets: 1024  Batches: 1  Memory Usage: 87kB
                     ->  Seq Scan on d t6  (cost=0.00..17.13 rows=413 width=178) (actual time=0.008..0.597 rows=413 loops=1)
 Total runtime: 1724.952 ms
(32 rows)
rssa

Per node type stats

node type	count	sum of times	% of query
Hash	4	48.529 ms	2.8 %
Hash Join	4	807.531 ms	46.8 %
Limit	1	0.026 ms	0.0 %
Nested Loop	1	69.986 ms	4.1 %
Seq Scan	6	691.010 ms	40.1 %
Sort	1	107.624 ms	6.2 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
a	1	280.437 ms	16.3 %
Seq Scan	1	280.437 ms	100.0 %
b	1	0.260 ms	0.0 %
Seq Scan	1	0.260 ms	100.0 %
c	1	409.150 ms	23.7 %
Seq Scan	1	409.150 ms	100.0 %
d	2	1.149 ms	0.1 %
Seq Scan	2	1.149 ms	100.0 %
e	1	0.014 ms	0.0 %
Seq Scan	1	0.014 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y9f

Colorize:

Columns visibility:

Per node type stats

Per table stats