explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7viJ

Settings
# exclusive inclusive rows x rows loops node
1. 1,903.427 74,771.279 ↑ 1.0 6,075,468 1

Unique (cost=1,614,753.25..1,676,953.52 rows=6,220,027 width=436) (actual time=72,004.503..74,771.279 rows=6,075,468 loops=1)

2. 67,989.404 72,867.852 ↓ 1.0 6,291,382 1

Sort (cost=1,614,753.25..1,630,303.32 rows=6,220,027 width=436) (actual time=72,004.502..72,867.852 rows=6,291,382 loops=1)

  • Sort Key: fa.dynamic_flight_group_key, p.ap_id, p.room_group, p.price_current
  • Sort Method: quicksort Memory: 1867757kB
3. 3,503.406 4,878.448 ↓ 1.0 6,291,382 1

Hash Join (cost=62,639.41..912,870.18 rows=6,220,027 width=436) (actual time=307.758..4,878.448 rows=6,291,382 loops=1)

  • Hash Cond: (p.flight_group_key = fa.flight_group_key)
4. 1,067.300 1,067.300 ↓ 3.3 7,820,154 1

Seq Scan on prices_1100 p (cost=0.00..625,612.00 rows=2,406,200 width=164) (actual time=0.004..1,067.300 rows=7,820,154 loops=1)

5. 129.857 307.742 ↓ 1,140.2 589,469 1

Hash (cost=62,632.95..62,632.95 rows=517 width=448) (actual time=307.742..307.742 rows=589,469 loops=1)

  • Buckets: 1048576 (originally 1024) Batches: 1 (originally 1) Memory Usage: 91087kB
6. 15.421 177.885 ↓ 1,140.2 589,469 1

Gather (cost=1,000.00..62,632.95 rows=517 width=448) (actual time=3.344..177.885 rows=589,469 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
7. 162.464 162.464 ↓ 913.9 196,490 3

Parallel Seq Scan on flights_all fa (cost=0.00..61,581.25 rows=215 width=448) (actual time=1.113..162.464 rows=196,490 loops=3)

  • Filter: (d3pf AND (seats >= 2) AND (stay = (bedbanks_nights + 1)))
  • Rows Removed by Filter: 10379
Planning time : 0.515 ms