explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eVFiF

Settings
# exclusive inclusive rows x rows loops node
1. 169.860 23,549.079 ↓ 167.5 1,236,042 1

Subquery Scan on rec (cost=1,628,601.89..1,676,580.92 rows=7,381 width=41) (actual time=22,171.986..23,549.079 rows=1,236,042 loops=1)

  • Filter: (rec.mpos = 1)
  • Rows Removed by Filter: 228,737
  • Buffers: shared hit=45 read=1,166,951
  • I/O Timings: read=29.530
2. 895.175 23,379.219 ↑ 1.0 1,464,779 1

WindowAgg (cost=1,628,601.89..1,658,127.45 rows=1,476,278 width=49) (actual time=22,171.983..23,379.219 rows=1,464,779 loops=1)

  • Buffers: shared hit=45 read=1,166,951
  • I/O Timings: read=29.530
3. 12,055.984 22,484.044 ↑ 1.0 1,464,779 1

Sort (cost=1,628,601.89..1,632,292.58 rows=1,476,278 width=41) (actual time=22,171.963..22,484.044 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=45 read=1,166,951
  • I/O Timings: read=29.530
4. 277.735 10,428.060 ↑ 1.0 1,464,779 1

Gather (cost=1,000.00..1,477,331.13 rows=1,476,278 width=41) (actual time=1.296..10,428.060 rows=1,464,779 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=39 read=1,166,951
  • I/O Timings: read=29.530
5. 10,150.325 10,150.325 ↑ 1.3 488,260 3 / 3

Parallel Seq Scan on receiving_item_delivered_received (cost=0.00..1,328,703.33 rows=615,116 width=41) (actual time=1.262..10,150.325 rows=488,260 loops=3)

  • Filter: (((COALESCE(serial_no, ''::character varying))::text <> ''::text) AND ((eventtype)::text = 'LineItemdetailsReceived'::text) AND ((replenishmenttype)::text = 'DC2SWARRANTY'::text))
  • Rows Removed by Filter: 6,906,258
  • Buffers: shared hit=39 read=1,166,951
  • I/O Timings: read=29.530
Planning time : 0.375 ms