explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9Vu7

Settings
# exclusive inclusive rows x rows loops node
1. 442.692 29,099.104 ↓ 3.2 869,358 1

Unique (cost=948,316.24..950,364.40 rows=273,089 width=778) (actual time=28,176.687..29,099.104 rows=869,358 loops=1)

2. 24,296.766 28,656.412 ↓ 3.2 870,317 1

Sort (cost=948,316.24..948,998.96 rows=273,089 width=778) (actual time=28,176.681..28,656.412 rows=870,317 loops=1)

  • Sort Key: p.price_key, f.flight_key
  • Sort Method: external sort Disk: 759800kB
3. 0.000 4,359.646 ↓ 3.2 870,317 1

Gather (cost=35,813.46..829,381.65 rows=273,089 width=778) (actual time=81.611..4,359.646 rows=870,317 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 763.740 5,473.676 ↓ 2.5 290,106 3

Hash Join (cost=34,813.46..797,886.71 rows=113,787 width=778) (actual time=78.624..5,473.676 rows=290,106 loops=3)

  • Hash Cond: (p.ap_id = l.ap_id)
5. 936.435 4,707.936 ↓ 2.5 290,110 3

Hash Join (cost=34,694.42..795,192.80 rows=113,787 width=469) (actual time=76.534..4,707.936 rows=290,110 loops=3)

  • Hash Cond: (p.flight_group_key = f.flight_group_key)
6. 3,711.477 3,711.477 ↑ 1.2 2,002,563 3

Parallel Seq Scan on prices_1000 p (cost=0.00..493,420.05 rows=2,502,969 width=270) (actual time=0.003..3,711.477 rows=2,002,563 loops=3)

  • Filter: (price_current > 0)
7. 6.080 60.024 ↑ 1.0 8,305 3

Hash (cost=34,590.05..34,590.05 rows=8,350 width=225) (actual time=60.024..60.024 rows=8,305 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 2270kB
8. 53.944 53.944 ↑ 1.0 8,305 3

Index Scan using ix_flightsall_test_sst on flights_all_test f (cost=0.42..34,590.05 rows=8,350 width=225) (actual time=0.026..53.944 rows=8,305 loops=3)

  • Index Cond: (d3pf = false)
  • Filter: ((NOT d3pf) AND (seats >= 5))
  • Rows Removed by Filter: 2738
9. 1.123 2.000 ↑ 1.0 2,846 3

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

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

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

Planning time : 1.688 ms