explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M2lP

Settings
# exclusive inclusive rows x rows loops node
1. 654.622 36,335.768 ↓ 3.2 869,358 1

Unique (cost=695,247.52..697,295.68 rows=273,088 width=778) (actual time=35,414.557..36,335.768 rows=869,358 loops=1)

2. 22,684.805 35,681.146 ↓ 3.2 870,317 1

Sort (cost=695,247.52..695,930.24 rows=273,088 width=778) (actual time=35,414.554..35,681.146 rows=870,317 loops=1)

  • Sort Key: p.price_key, f.flight_key
  • Sort Method: quicksort Memory: 908492kB
3. 1,953.339 12,996.341 ↓ 3.2 870,317 1

Hash Join (cost=612,434.60..670,589.03 rows=273,088 width=778) (actual time=10,449.396..12,996.341 rows=870,317 loops=1)

  • Hash Cond: (p.ap_id = l.ap_id)
4. 592.350 11,041.198 ↓ 3.2 870,330 1

Hash Join (cost=612,315.56..664,290.31 rows=273,088 width=469) (actual time=10,447.567..11,041.198 rows=870,330 loops=1)

  • Hash Cond: (f.flight_group_key = p.flight_group_key)
5. 40.724 40.724 ↑ 1.0 8,305 1

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.020..40.724 rows=8,305 loops=1)

  • Index Cond: (d3pf = false)
  • Filter: ((NOT d3pf) AND (seats >= 5))
  • Rows Removed by Filter: 2738
6. 4,364.366 10,408.124 ↓ 1.0 6,007,688 1

Hash (cost=537,226.10..537,226.10 rows=6,007,123 width=270) (actual time=10,408.124..10,408.124 rows=6,007,688 loops=1)

  • Buckets: 8388608 Batches: 1 Memory Usage: 1860803kB
7. 6,043.758 6,043.758 ↓ 1.0 6,007,688 1

Seq Scan on prices_1000 p (cost=0.00..537,226.10 rows=6,007,123 width=270) (actual time=0.007..6,043.758 rows=6,007,688 loops=1)

  • Filter: (price_current > 0)
8. 0.947 1.804 ↑ 1.0 2,846 1

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

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

Seq Scan on locations l (cost=0.00..83.46 rows=2,846 width=85) (actual time=0.023..0.857 rows=2,846 loops=1)