explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SPJe

Settings
# exclusive inclusive rows x rows loops node
1. 46.133 3,458.344 ↓ 189.5 333,451 1

Subquery Scan on rec (cost=70,835.30..82,275.49 rows=1,760 width=39) (actual time=2,331.293..3,458.344 rows=333,451 loops=1)

  • Filter: (rec.mpos = 1)
  • Rows Removed by Filter: 19,900
  • Buffers: shared hit=21,615, temp read=2,178 written=2,187
2. 230.061 3,412.211 ↓ 1.0 353,351 1

WindowAgg (cost=70,835.30..77,875.42 rows=352,006 width=47) (actual time=2,331.291..3,412.211 rows=353,351 loops=1)

  • Buffers: shared hit=21,615, temp read=2,178 written=2,187
3. 2,988.624 3,182.150 ↓ 1.0 353,351 1

Sort (cost=70,835.30..71,715.31 rows=352,006 width=39) (actual time=2,331.278..3,182.150 rows=353,351 loops=1)

  • Sort Key: receiving_item_delivered_received.serial_no, receiving_item_delivered_received.eventtime DESC
  • Sort Method: external merge Disk: 17,424kB
  • Buffers: shared hit=21,615, temp read=2,178 written=2,187
4. 193.526 193.526 ↓ 1.0 353,351 1

Seq Scan on receiving_item_delivered_received (cost=0.00..28,777.82 rows=352,006 width=39) (actual time=0.008..193.526 rows=353,351 loops=1)

  • Filter: (((COALESCE(serial_no, ''::character varying))::text <> ''::text) AND ((eventtype)::text = 'LineItemdetailsReceived'::text) AND ((replenishmenttype)::text = 'DC2SWARRANTY'::text))
  • Rows Removed by Filter: 55,953
  • Buffers: shared hit=21,615
Planning time : 0.202 ms