explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H5On

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 5,229.979 ↑ 1.1 8 1

Sort (cost=299,641.34..299,641.36 rows=9 width=40) (actual time=5,229.976..5,229.979 rows=8 loops=1)

  • Sort Key: (count(*)) DESC
  • Sort Method: quicksort Memory: 25kB
2. 1,161.770 5,229.968 ↑ 1.1 8 1

HashAggregate (cost=299,641.10..299,641.19 rows=9 width=40) (actual time=5,229.965..5,229.968 rows=8 loops=1)

  • Group Key: ((ml.model ->> lang()))
3. 1,226.869 4,068.198 ↑ 1.0 7,925,812 1

Hash Left Join (cost=8,301.98..260,011.38 rows=7,925,944 width=32) (actual time=74.360..4,068.198 rows=7,925,812 loops=1)

  • Hash Cond: (f.aircraft_code = ml.aircraft_code)
4. 1,944.477 2,841.245 ↑ 1.0 7,925,812 1

Hash Left Join (cost=8,298.51..229,404.96 rows=7,925,944 width=4) (actual time=74.262..2,841.245 rows=7,925,812 loops=1)

  • Hash Cond: (bp.flight_id = f.flight_id)
5. 823.121 823.121 ↑ 1.0 7,925,812 1

Seq Scan on boarding_passes bp (cost=0.00..137,538.44 rows=7,925,944 width=4) (actual time=0.020..823.121 rows=7,925,812 loops=1)

6. 39.302 73.647 ↑ 1.0 214,867 1

Hash (cost=4,772.67..4,772.67 rows=214,867 width=8) (actual time=73.647..73.647 rows=214,867 loops=1)

  • Buckets: 131,072 Batches: 4 Memory Usage: 3,127kB
7. 34.345 34.345 ↑ 1.0 214,867 1

Seq Scan on flights f (cost=0.00..4,772.67 rows=214,867 width=8) (actual time=0.015..34.345 rows=214,867 loops=1)

8. 0.013 0.084 ↑ 1.0 9 1

Hash (cost=3.36..3.36 rows=9 width=48) (actual time=0.083..0.084 rows=9 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
9. 0.071 0.071 ↑ 1.0 9 1

Seq Scan on aircrafts_data ml (cost=0.00..3.36 rows=9 width=48) (actual time=0.057..0.071 rows=9 loops=1)

Planning time : 0.491 ms
Execution time : 5,230.450 ms