explain.depesz.com

PostgreSQL's explain analyze made readable

Result: scTs

Settings
# exclusive inclusive rows x rows loops node
1. 2,659.920 12,884.808 ↓ 188.1 250,978 1

Seq Scan on invoice_info ii (cost=0.00..96,982,319.37 rows=1,334 width=51) (actual time=326.232..12,884.808 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=2995254 read=54363
2.          

SubPlan (forSeq Scan)

3. 538.152 10,224.888 ↑ 1.0 1 269,076

Aggregate (cost=27.94..27.95 rows=1 width=4) (actual time=0.038..0.038 rows=1 loops=269,076)

  • Buffers: shared hit=2986788
4. 9,686.736 9,686.736 ↓ 1.2 7 269,076

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

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