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 1,474,805.855 ↓ 5.8 517,069 1

Nested Loop (cost=0.00..25,411,770.40 rows=89,303 width=13) (actual time=0.028..1,474,805.855 rows=517,069 loops=1)

2. 1,190.788 1,190.788 ↑ 1.0 517,069 1

Seq Scan on april_sample (cost=0.00..21,656.69 rows=517,069 width=12) (actual time=0.009..1,190.788 rows=517,069 loops=1)

3. 1,473,129.581 1,473,129.581 ↑ 1.0 1 517,069

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=517,069)

  • 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))