explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Zla0

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# 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))