explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ioKk

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

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

  • Filter: (rec.mpos = 1)
  • Rows Removed by Filter: 19,900
2. 224.294 3,414.384 ↓ 1.0 353,351 1

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

3. 3,005.413 3,190.090 ↓ 1.0 353,351 1

Sort (cost=70,835.30..71,715.31 rows=352,006 width=39) (actual time=2,322.983..3,190.090 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
4. 184.677 184.677 ↓ 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.011..184.677 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
Planning time : 0.197 ms
Execution time : 3,466.985 ms