explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fP6A

Settings
# exclusive inclusive rows x rows loops node
1. 456.374 23,463.975 ↓ 3.2 869,358 1

Unique (cost=875,230.43..877,278.59 rows=273,088 width=778) (actual time=18,923.643..23,463.975 rows=869,358 loops=1)

2. 21,383.058 23,007.601 ↓ 3.2 870,317 1

Sort (cost=875,230.43..875,913.15 rows=273,088 width=778) (actual time=18,923.641..23,007.601 rows=870,317 loops=1)

  • Sort Key: p.price_key, f.flight_key
  • Sort Method: external merge Disk: 759832kB
3. 213.545 1,624.543 ↓ 3.2 870,317 1

Gather (cost=1,120.02..756,295.94 rows=273,088 width=778) (actual time=2.931..1,624.543 rows=870,317 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 723.279 1,410.998 ↓ 2.5 290,106 3

Hash Join (cost=120.02..724,801.12 rows=113,787 width=778) (actual time=2.171..1,410.998 rows=290,106 loops=3)

  • Hash Cond: (p.ap_id = l.ap_id)
5. 672.381 685.699 ↓ 2.5 290,110 3

Nested Loop (cost=0.98..722,107.21 rows=113,787 width=469) (actual time=0.086..685.699 rows=290,110 loops=3)

6. 13.213 13.213 ↑ 1.3 2,768 3

Parallel Index Scan using ix_flightsall_test_sst on flights_all_test f (cost=0.42..34,510.99 rows=3,479 width=225) (actual time=0.019..13.213 rows=2,768 loops=3)

  • Index Cond: (d3pf = false)
  • Filter: ((NOT d3pf) AND (seats >= 5))
  • Rows Removed by Filter: 913
7. 0.105 0.105 ↓ 1.2 105 8,305

Index Scan using ix_prices_test1 on prices_1000 p (cost=0.56..196.80 rows=84 width=270) (actual time=0.015..0.105 rows=105 loops=8,305)

  • Index Cond: ((flight_group_key = f.flight_group_key) AND (price_current > 0))
8. 1.110 2.020 ↑ 1.0 2,846 3

Hash (cost=83.46..83.46 rows=2,846 width=85) (actual time=2.019..2.020 rows=2,846 loops=3)

  • Buckets: 4096 Batches: 1 Memory Usage: 363kB
9. 0.910 0.910 ↑ 1.0 2,846 3

Seq Scan on locations l (cost=0.00..83.46 rows=2,846 width=85) (actual time=0.006..0.910 rows=2,846 loops=3)