explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GE9w

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 2,777.740 14,078.932 ↓ 191.1 250,978 1

Seq Scan on invoice_info ii (cost=0.00..96,871,002.05 rows=1,313 width=51) (actual time=172.898..14,078.932 rows=250,978 loops=1)

  • Filter: ((input_date >= to_date('10-12-2018'::text, 'dd.mm.yyyy'::text)) AND (input_date <= to_date('11-12-2018'::text, 'dd.mm.yyyy'::text)) AND (last_update_date = (SubPlan 1)))
  • Rows Removed by Filter: 3213754
  • Buffers: shared hit=3000598 read=49019
2.          

SubPlan (forSeq Scan)

3. 807.228 11,301.192 ↑ 1.0 1 269,076

Aggregate (cost=27.91..27.92 rows=1 width=4) (actual time=0.042..0.042 rows=1 loops=269,076)

  • Buffers: shared hit=2986788
4. 10,493.964 10,493.964 ↓ 1.2 7 269,076

Index Scan using invoice_info_regnum_idx on invoice_info if (cost=0.56..27.89 rows=6 width=4) (actual time=0.036..0.039 rows=7 loops=269,076)

  • Index Cond: ((registration_number)::text = (ii.registration_number)::text)
  • Buffers: shared hit=2986788