explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NE9Y

Settings
# exclusive inclusive rows x rows loops node
1. 2,634.245 6,205.836 ↓ 1.9 31 1

HashAggregate (cost=322,582.34..322,583.22 rows=16 width=188) (actual time=6,205.776..6,205.836 rows=31 loops=1)

  • Group Key: e0_.id
2. 715.589 3,571.591 ↓ 2.4 2,246,666 1

Hash Join (cost=18,413.56..258,946.58 rows=942,752 width=54) (actual time=142.629..3,571.591 rows=2,246,666 loops=1)

  • Hash Cond: (e1_.best_practice_fk = e0_.id)
3. 1,659.887 2,855.873 ↓ 1.2 2,308,477 1

Hash Join (cost=18,407.10..242,221.00 rows=1,944,426 width=54) (actual time=142.488..2,855.873 rows=2,308,477 loops=1)

  • Hash Cond: (e1_.meta_flight_fk = e5_.id)
4. 1,054.704 1,054.704 ↑ 1.0 7,014,665 1

Seq Scan on meta_flight_bp_values e1_ (cost=0.00..178,064.65 rows=7,014,665 width=58) (actual time=0.006..1,054.704 rows=7,014,665 loops=1)

5. 31.483 141.282 ↓ 1.0 139,787 1

Hash (cost=16,670.01..16,670.01 rows=138,967 width=4) (actual time=141.282..141.282 rows=139,787 loops=1)

  • Buckets: 262,144 Batches: 1 Memory Usage: 6,963kB
6. 109.799 109.799 ↓ 1.0 139,787 1

Seq Scan on meta_flight e5_ (cost=0.00..16,670.01 rows=138,967 width=4) (actual time=0.029..109.799 rows=139,787 loops=1)

  • Filter: ((dep_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (dep_date <= '2020-01-21 23:59:59.999999'::timestamp without time zone))
  • Rows Removed by Filter: 361,547
7. 0.002 0.129 ↓ 1.9 31 1

Hash (cost=6.26..6.26 rows=16 width=4) (actual time=0.129..0.129 rows=31 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
8. 0.032 0.127 ↓ 1.9 31 1

Hash Join (cost=4.53..6.26 rows=16 width=4) (actual time=0.095..0.127 rows=31 loops=1)

  • Hash Cond: (b4_.domain_fk = p3_.id)
9. 0.019 0.082 ↓ 1.9 31 1

Hash Join (cost=3.37..5.01 rows=16 width=8) (actual time=0.071..0.082 rows=31 loops=1)

  • Hash Cond: (b4_.bp_fk = e0_.bp_definition_fk)
10. 0.006 0.006 ↑ 1.0 35 1

Seq Scan on bp_domain_link b4_ (cost=0.00..1.35 rows=35 width=8) (actual time=0.003..0.006 rows=35 loops=1)

11. 0.008 0.057 ↓ 1.9 31 1

Hash (cost=3.17..3.17 rows=16 width=12) (actual time=0.057..0.057 rows=31 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
12. 0.026 0.049 ↓ 1.9 31 1

Hash Join (cost=1.53..3.17 rows=16 width=12) (actual time=0.033..0.049 rows=31 loops=1)

  • Hash Cond: (p2_.id = e0_.bp_definition_fk)
13. 0.005 0.005 ↑ 1.0 35 1

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

14. 0.010 0.018 ↓ 1.9 31 1

Hash (cost=1.33..1.33 rows=16 width=8) (actual time=0.018..0.018 rows=31 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
15. 0.008 0.008 ↓ 1.9 31 1

Seq Scan on best_practice e0_ (cost=0.00..1.33 rows=16 width=8) (actual time=0.003..0.008 rows=31 loops=1)

  • Filter: is_visible_for_airline
  • Rows Removed by Filter: 2
16. 0.007 0.013 ↑ 1.0 7 1

Hash (cost=1.07..1.07 rows=7 width=4) (actual time=0.013..0.013 rows=7 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
17. 0.006 0.006 ↑ 1.0 7 1

Seq Scan on domain p3_ (cost=0.00..1.07 rows=7 width=4) (actual time=0.005..0.006 rows=7 loops=1)