explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ktbv : Optimization for: plan #HaOx

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 173.5 1,237,781 1

Subquery Scan on rec (cost=1,477,985.64..1,524,357.03 rows=7,134 width=41) (actual rows=1,237,781 loops=1)

  • Filter: (rec.mpos = 1)
  • Rows Removed by Filter: 229,272
  • Buffers: shared hit=172,011
2. 0.000 0.000 ↓ 1.0 1,467,053 1

WindowAgg (cost=1,477,985.64..1,506,521.88 rows=1,426,812 width=49) (actual rows=1,467,053 loops=1)

  • Buffers: shared hit=172,011
3. 0.000 0.000 ↓ 1.0 1,467,053 1

Sort (cost=1,477,985.64..1,481,552.67 rows=1,426,812 width=41) (actual rows=1,467,053 loops=1)

  • Sort Key: receiving_item_delivered_received.serial_no, receiving_item_delivered_received.eventtime DESC
  • Sort Method: quicksort Memory: 163,766kB
  • Buffers: shared hit=172,011
4. 0.000 0.000 ↓ 1.0 1,467,053 1

Bitmap Heap Scan on receiving_item_delivered_received (cost=75,065.09..1,332,134.32 rows=1,426,812 width=41) (actual rows=1,467,053 loops=1)

  • Recheck Cond: (((eventtype)::text = 'LineItemdetailsReceived'::text) AND ((replenishmenttype)::text = 'DC2SWARRANTY'::text))
  • Filter: ((COALESCE(serial_no, ''::character varying))::text <> ''::text)
  • Rows Removed by Filter: 23
  • Heap Blocks: exact=156,742
  • Buffers: shared hit=172,011
5. 0.000 0.000 ↓ 1.0 1,467,076 1

Bitmap Index Scan on receiving_item_delivered_received_idx (cost=0.00..74,708.38 rows=1,433,982 width=0) (actual rows=1,467,076 loops=1)

  • Index Cond: (((eventtype)::text = 'LineItemdetailsReceived'::text) AND ((replenishmenttype)::text = 'DC2SWARRANTY'::text))
  • Buffers: shared hit=15,269
Planning time : 0.126 ms