explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HaOx

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 167.108 13,639.951 ↓ 167.4 1,236,042 1

Subquery Scan on rec (cost=1,484,136.69..1,532,129.80 rows=7,384 width=41) (actual time=12,376.688..13,639.951 rows=1,236,042 loops=1)

  • Filter: (rec.mpos = 1)
  • Rows Removed by Filter: 228,737
  • Buffers: shared hit=171,461 read=1
  • I/O Timings: read=0.858
2. 839.522 13,472.843 ↑ 1.0 1,464,779 1

WindowAgg (cost=1,484,136.69..1,513,670.91 rows=1,476,711 width=49) (actual time=12,376.686..13,472.843 rows=1,464,779 loops=1)

  • Buffers: shared hit=171,461 read=1
  • I/O Timings: read=0.858
3. 11,525.107 12,633.321 ↑ 1.0 1,464,779 1

Sort (cost=1,484,136.69..1,487,828.47 rows=1,476,711 width=41) (actual time=12,376.664..12,633.321 rows=1,464,779 loops=1)

  • Sort Key: receiving_item_delivered_received.serial_no, receiving_item_delivered_received.eventtime DESC
  • Sort Method: quicksort Memory: 163,589kB
  • Buffers: shared hit=171,461 read=1
  • I/O Timings: read=0.858
4. 897.834 1,108.214 ↑ 1.0 1,464,779 1

Bitmap Heap Scan on receiving_item_delivered_received (cost=77,619.05..1,332,818.44 rows=1,476,711 width=41) (actual time=240.392..1,108.214 rows=1,464,779 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,193
  • Buffers: shared hit=171,455 read=1
  • I/O Timings: read=0.858
5. 210.380 210.380 ↑ 1.0 1,464,802 1

Bitmap Index Scan on receiving_item_delivered_received_idx (cost=0.00..77,249.87 rows=1,484,131 width=0) (actual time=210.380..210.380 rows=1,464,802 loops=1)

  • Index Cond: (((eventtype)::text = 'LineItemdetailsReceived'::text) AND ((replenishmenttype)::text = 'DC2SWARRANTY'::text))
  • Buffers: shared hit=15,262 read=1
  • I/O Timings: read=0.858
Planning time : 0.420 ms