explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZUqU

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 2,168.564 ↑ 1.0 60 1

Limit (cost=619,763.80..619,770.80 rows=60 width=2,115) (actual time=2,167.026..2,168.564 rows=60 loops=1)

2. 0.000 2,168.558 ↑ 47,056.4 60 1

Gather Merge (cost=619,763.80..949,181.83 rows=2,823,386 width=2,115) (actual time=2,167.025..2,168.558 rows=60 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 2,618.601 6,490.701 ↑ 30,689.0 46 3

Sort (cost=618,763.77..622,293.01 rows=1,411,693 width=2,115) (actual time=2,163.565..2,163.567 rows=46 loops=3)

  • Sort Key: scheduled_pick_up_time_from DESC NULLS LAST
  • Sort Method: top-N heapsort Memory: 155kB
  • Worker 0: Sort Method: top-N heapsort Memory: 166kB
  • Worker 1: Sort Method: top-N heapsort Memory: 164kB
4. 3,872.100 3,872.100 ↑ 1.3 1,126,264 3

Parallel Seq Scan on shipments (cost=0.00..570,011.73 rows=1,411,693 width=2,115) (actual time=0.046..1,290.700 rows=1,126,264 loops=3)

  • Filter: ((NOT is_quote) AND ((type)::text = 'TourShipment'::text))
  • Rows Removed by Filter: 87117
Planning time : 3.520 ms
Execution time : 2,168.705 ms