#	exclusive	inclusive	rows x	rows	loops	node
1.	485.486	1474805.855	↓ 5.8	517069	1	→ Nested Loop (cost=0.00..25411770.40 rows=89303 width=13) (actual time=0.028..1474805.855 rows=517069 loops=1)
2.	1190.788	1190.788	↑ 1.0	517069	1	→ Seq Scan on april_sample (cost=0.00..21656.69 rows=517069 width=12) (actual time=0.009..1190.788 rows=517069 loops=1)
3.	1473129.581	1473129.581	↑ 1.0	1	517069	→ Index Scan using invdat_all_pkey on invdat_all i (cost=0.00..49.09 rows=1 width=9) (actual time=2.828..2.849 rows=1 loops=517069) Index Cond: (invno = april_sample.invno) Filter: ((create_date >= '2011-06-01 00:00:00'::timestamp without time zone) AND (create_date <= '2011-11-01 00:00:00'::timestamp without time zone))

Nested Loop  (cost=0.00..25411770.40 rows=89303 width=13) (actual time=0.028..1474805.855 rows=517069 loops=1)
  ->  Seq Scan on april_sample  (cost=0.00..21656.69 rows=517069 width=12) (actual time=0.009..1190.788 rows=517069 loops=1)
  ->  Index Scan using invdat_all_pkey on invdat_all i  (cost=0.00..49.09 rows=1 width=9) (actual time=2.828..2.849 rows=1 loops=517069)
        Index Cond: (invno = april_sample.invno)
        Filter: ((create_date >= '2011-06-01 00:00:00'::timestamp without time zone) AND (create_date <= '2011-11-01 00:00:00'::timestamp without time zone))
Total runtime: 1474871.575 ms

Per node type stats

node type	count	sum of times	% of query
Index Scan	1	1473129.581 ms	99.9 %
Nested Loop	1	485.486 ms	0.0 %
Seq Scan	1	1190.788 ms	0.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
april_sample	1	1190.788 ms	0.1 %
Seq Scan	1	1190.788 ms	100.0 %
invdat_all	1	1473129.581 ms	99.9 %
Index Scan	1	1473129.581 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Zla0

Colorize:

Columns visibility:

Per node type stats

Per table stats