explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fvp0

Settings
# exclusive inclusive rows x rows loops node
1. 5,007.809 167,850.213 ↓ 14.5 250,978 1

Seq Scan on invoice_info ii (cost=0.00..97,112,246.82 rows=17,324 width=51) (actual time=26,636.212..167,850.213 rows=250,978 loops=1)

  • Filter: (last_update_date = (SubPlan 1))
  • Rows Removed by Filter: 3213754
  • Buffers: shared hit=34436202 read=836259
2.          

SubPlan (forSeq Scan)

3. 3,464.732 162,842.404 ↑ 1.0 1 3,464,732

Aggregate (cost=27.99..28.00 rows=1 width=4) (actual time=0.047..0.047 rows=1 loops=3,464,732)

  • Buffers: shared hit=34434233 read=775399
4. 159,377.672 159,377.672 ↑ 1.0 1 3,464,732

Index Scan using invoice_info_regnum_idx on invoice_info if (cost=0.56..27.99 rows=1 width=4) (actual time=0.045..0.046 rows=1 loops=3,464,732)

  • Index Cond: ((registration_number)::text = (ii.registration_number)::text)
  • 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)))
  • Rows Removed by Filter: 6
  • Buffers: shared hit=34434233 read=775399