explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IRg9 : Optimization for: Optimization for: plan #GE9w; plan #Doe4

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 2,766.134 15,681.782 ↓ 191.1 250,978 1

Seq Scan on invoice_info ii (cost=0.00..98,974,541.33 rows=1,313 width=51) (actual time=109.152..15,681.782 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
2.          

SubPlan (forSeq Scan)

3. 1,076.304 12,915.648 ↑ 1.0 1 269,076

Aggregate (cost=28.52..28.53 rows=1 width=4) (actual time=0.048..0.048 rows=1 loops=269,076)

4. 2,152.608 11,839.344 ↓ 1.2 7 269,076

Bitmap Heap Scan on invoice_info if (cost=4.60..28.50 rows=6 width=4) (actual time=0.039..0.044 rows=7 loops=269,076)

  • Recheck Cond: ((registration_number)::text = (ii.registration_number)::text)
  • Heap Blocks: exact=1963401
5. 9,686.736 9,686.736 ↓ 1.2 7 269,076

Bitmap Index Scan on invoice_info_regnum_idx (cost=0.00..4.60 rows=6 width=0) (actual time=0.036..0.036 rows=7 loops=269,076)

  • Index Cond: ((registration_number)::text = (ii.registration_number)::text)