explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PPzH

Settings
# exclusive inclusive rows x rows loops node
1. 5,061.547 13,680.455 ↑ 1.0 1 1

Aggregate (cost=712,371.78..712,371.79 rows=1 width=32) (actual time=13,680.455..13,680.455 rows=1 loops=1)

2. 4,782.797 8,618.908 ↓ 1.3 23,537,276 1

Hash Join (cost=28,524.43..536,068.50 rows=17,630,328 width=32) (actual time=1,781.205..8,618.908 rows=23,537,276 loops=1)

  • Hash Cond: (p1_.id = e0_.bp_fk)
3. 719.798 3,835.940 ↓ 1.3 2,237,112 1

Hash Join (cost=28,512.77..356,441.83 rows=1,677,525 width=12) (actual time=1,781.027..3,835.940 rows=2,237,112 loops=1)

  • Hash Cond: (e3_.bp_definition_fk = p1_.id)
4. 1,292.770 3,116.101 ↓ 1.2 2,298,868 1

Hash Join (cost=28,508.87..332,560.26 rows=1,893,980 width=4) (actual time=1,780.978..3,116.101 rows=2,298,868 loops=1)

  • Hash Cond: (e3_.meta_flight_fk = e4_.id)
5. 1,747.288 1,747.288 ↓ 1.0 7,014,665 1

Index Only Scan using unique_meta_flight_bp_values on meta_flight_bp_values e3_ (cost=0.43..258,864.11 rows=6,999,445 width=8) (actual time=0.010..1,747.288 rows=7,014,665 loops=1)

  • Heap Fetches: 0
6. 26.410 76.043 ↓ 1.0 138,102 1

Hash (cost=26,812.74..26,812.74 rows=135,656 width=4) (actual time=76.043..76.043 rows=138,102 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 6904kB
7. 36.087 49.633 ↓ 1.0 138,102 1

Bitmap Heap Scan on meta_flight e4_ (cost=4,950.90..26,812.74 rows=135,656 width=4) (actual time=14.559..49.633 rows=138,102 loops=1)

  • Recheck Cond: ((dep_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (dep_date <= '2020-01-17 23:59:59.999999'::timestamp without time zone))
  • Heap Blocks: exact=6858
8. 13.546 13.546 ↓ 1.0 138,102 1

Bitmap Index Scan on index_meta_flight_dep_date (cost=0.00..4,916.98 rows=135,656 width=0) (actual time=13.546..13.546 rows=138,102 loops=1)

  • Index Cond: ((dep_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (dep_date <= '2020-01-17 23:59:59.999999'::timestamp without time zone))
9. 0.005 0.041 ↑ 1.0 31 1

Hash (cost=3.51..3.51 rows=31 width=8) (actual time=0.041..0.041 rows=31 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
10. 0.015 0.036 ↑ 1.0 31 1

Hash Join (cost=1.72..3.51 rows=31 width=8) (actual time=0.021..0.036 rows=31 loops=1)

  • Hash Cond: (p1_.id = e2_.bp_definition_fk)
11. 0.007 0.007 ↑ 1.0 35 1

Seq Scan on bp_definition p1_ (cost=0.00..1.35 rows=35 width=4) (actual time=0.003..0.007 rows=35 loops=1)

12. 0.005 0.014 ↑ 1.0 31 1

Hash (cost=1.33..1.33 rows=31 width=4) (actual time=0.014..0.014 rows=31 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
13. 0.009 0.009 ↑ 1.0 31 1

Seq Scan on best_practice e2_ (cost=0.00..1.33 rows=31 width=4) (actual time=0.002..0.009 rows=31 loops=1)

  • Filter: is_visible_for_airline
  • Rows Removed by Filter: 2
14. 0.055 0.171 ↑ 1.0 296 1

Hash (cost=7.96..7.96 rows=296 width=36) (actual time=0.171..0.171 rows=296 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 28kB
15. 0.116 0.116 ↑ 1.0 296 1

Seq Scan on reference_marks e0_ (cost=0.00..7.96 rows=296 width=36) (actual time=0.007..0.116 rows=296 loops=1)