explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3Gke

Settings
# exclusive inclusive rows x rows loops node
1. 639.467 3,528.530 ↓ 1.2 2,308,477 1

Hash Join (cost=15,917.98..267,194.29 rows=1,947,030 width=4) (actual time=106.375..3,528.530 rows=2,308,477 loops=1)

  • Hash Cond: (e1_.best_practice_fk = e0_.id)
2. 1,479.176 2,888.292 ↓ 1.2 2,308,477 1

Hash Join (cost=15,910.42..240,415.07 rows=1,947,030 width=4) (actual time=105.589..2,888.292 rows=2,308,477 loops=1)

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

Seq Scan on meta_flight_bp_values e1_ (cost=0.00..178,643.80 rows=7,037,480 width=8) (actual time=0.006..1,303.823 rows=7,014,665 loops=1)

4. 27.847 105.293 ↓ 1.0 139,787 1

Hash (cost=14,176.65..14,176.65 rows=138,702 width=4) (actual time=105.293..105.293 rows=139,787 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 6963kB
5. 36.521 77.446 ↓ 1.0 139,787 1

Bitmap Heap Scan on meta_flight e5_ (cost=2,946.12..14,176.65 rows=138,702 width=4) (actual time=41.801..77.446 rows=139,787 loops=1)

  • Recheck Cond: ((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))
  • Heap Blocks: exact=5658
6. 40.925 40.925 ↓ 1.0 139,787 1

Bitmap Index Scan on index_meta_flight_dep_date (cost=0.00..2,911.44 rows=138,702 width=0) (actual time=40.925..40.925 rows=139,787 loops=1)

  • Index Cond: ((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))
7. 0.007 0.771 ↑ 1.0 33 1

Hash (cost=7.15..7.15 rows=33 width=4) (actual time=0.771..0.771 rows=33 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
8. 0.015 0.764 ↑ 1.0 33 1

Hash Join (cost=4.69..7.15 rows=33 width=4) (actual time=0.725..0.764 rows=33 loops=1)

  • Hash Cond: (b4_.domain_fk = p3_.id)
9. 0.013 0.742 ↑ 1.0 33 1

Hash Join (cost=3.53..5.79 rows=33 width=8) (actual time=0.716..0.742 rows=33 loops=1)

  • Hash Cond: (e0_.bp_definition_fk = b4_.bp_fk)
10. 0.019 0.716 ↑ 1.0 33 1

Hash Join (cost=1.74..3.55 rows=33 width=12) (actual time=0.700..0.716 rows=33 loops=1)

  • Hash Cond: (p2_.id = e0_.bp_definition_fk)
11. 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.002..0.005 rows=35 loops=1)

12. 0.010 0.692 ↑ 1.0 33 1

Hash (cost=1.33..1.33 rows=33 width=8) (actual time=0.692..0.692 rows=33 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
13. 0.682 0.682 ↑ 1.0 33 1

Seq Scan on best_practice e0_ (cost=0.00..1.33 rows=33 width=8) (actual time=0.678..0.682 rows=33 loops=1)

14. 0.006 0.013 ↑ 1.0 35 1

Hash (cost=1.35..1.35 rows=35 width=8) (actual time=0.013..0.013 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
15. 0.007 0.007 ↑ 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.007 rows=35 loops=1)

16. 0.003 0.007 ↑ 1.0 7 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
17. 0.004 0.004 ↑ 1.0 7 1

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