explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EQyS

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

Hash Join (cost=15,912.17..267,188.48 rows=1,947,030 width=4) (actual time=82.472..3,354.279 rows=2,308,477 loops=1)

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

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

  • Hash Cond: (e1_.meta_flight_fk = e5_.id)
3. 1,099.205 1,099.205 ↑ 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.004..1,099.205 rows=7,014,665 loops=1)

4. 30.273 81.354 ↓ 1.0 139,787 1

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

  • Buckets: 262144 Batches: 1 Memory Usage: 6963kB
5. 38.040 51.081 ↓ 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=13.990..51.081 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. 13.041 13.041 ↓ 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=13.041..13.041 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.018 ↑ 1.0 33 1

Hash (cost=1.33..1.33 rows=33 width=4) (actual time=0.018..0.018 rows=33 loops=1)

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

Seq Scan on best_practice e0_ (cost=0.00..1.33 rows=33 width=4) (actual time=0.005..0.011 rows=33 loops=1)