explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OwH1

Settings
# exclusive inclusive rows x rows loops node
1. 103.533 138.709 ↓ 1.9 100,203 1

Gather Merge (cost=318,396.66..324,324.22 rows=51,544 width=6,972) (actual time=115.005..138.709 rows=100,203 loops=1)

  • Output: id, file_name, file_storage_path, msg_correlation_id, source, reception_timestamp, global_result_code, nb_of_accepted_devices, nb_of_rejected_devices, status, kms_id, delivery_note_number, shipment_date, order_id, order_position_id, device_type, (...)
  • Workers Planned: 1
  • Workers Launched: 1
  • Buffers: shared hit=1573, temp read=539 written=539
2. 15.770 35.176 ↑ 1.0 50,102 2 / 2

Sort (cost=317,396.65..317,525.51 rows=51,544 width=6,972) (actual time=30.687..35.176 rows=50,102 loops=2)

  • Output: id, file_name, file_storage_path, msg_correlation_id, source, reception_timestamp, global_result_code, nb_of_accepted_devices, nb_of_rejected_devices, status, kms_id, delivery_note_number, shipment_date, order_id, order_position_id, device_ (...)
  • Sort Key: oemassetsh0_.reception_timestamp DESC
  • Sort Method: external sort Disk: 4312kB
  • Buffers: shared hit=1573, temp read=539 written=539
  • Worker 0: actual time=0.146..0.146 rows=0 loops=1
  • Buffers: shared hit=48
3. 19.406 19.406 ↑ 1.0 50,102 2 / 2

Parallel Seq Scan on public.oem_asset_shipment_file oemassetsh0_ (cost=0.00..5,054.43 rows=51,544 width=6,972) (actual time=0.005..19.406 rows=50,102 loops=2)

  • Output: id, file_name, file_storage_path, msg_correlation_id, source, reception_timestamp, global_result_code, nb_of_accepted_devices, nb_of_rejected_devices, status, kms_id, delivery_note_number, shipment_date, order_id, order_position_id, d (...)
  • Filter: (((oemassetsh0_.status)::text = 'PENDING_QA'::text) OR ((oemassetsh0_.status)::text = 'QA_IN_PROGRESS'::text) OR ((oemassetsh0_.status)::text = 'APPROVED_BY_QA'::text) OR ((oemassetsh0_.status)::text = 'REJECTED_BY_QA'::text) OR ((oem (...)
  • Rows Removed by Filter: 49899
  • Buffers: shared hit=1525
  • Worker 0: actual time=0.004..0.004 rows=0 loops=1
Planning time : 0.107 ms
Execution time : 142.229 ms