explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tU9E

Settings
# exclusive inclusive rows x rows loops node
1. 64,866.470 117,215.359 ↓ 1.2 96,950,188 1

Hash Join (cost=14,921.64..7,829,351.36 rows=82,180,972 width=7) (actual time=70.098..117,215.359 rows=96,950,188 loops=1)

  • Hash Cond: (e0_.meta_flight_fk = e1_.id)
2. 52,279.424 52,279.424 ↓ 1.0 348,165,407 1

Seq Scan on computed_value e0_ (cost=0.00..5,687,023.00 rows=348,159,200 width=11) (actual time=0.008..52,279.424 rows=348,165,407 loops=1)

3. 22.500 69.465 ↑ 1.0 117,321 1

Hash (cost=13,442.43..13,442.43 rows=118,337 width=4) (actual time=69.465..69.465 rows=117,321 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 5149kB
4. 35.662 46.965 ↑ 1.0 117,321 1

Bitmap Heap Scan on meta_flight e1_ (cost=2,517.38..13,442.43 rows=118,337 width=4) (actual time=11.816..46.965 rows=117,321 loops=1)

  • Recheck Cond: ((dep_date >= '2018-01-01 00:00:00'::timestamp without time zone) AND (dep_date <= '2018-12-31 23:59:59.999999'::timestamp without time zone))
  • Heap Blocks: exact=3604
5. 11.303 11.303 ↑ 1.0 117,321 1

Bitmap Index Scan on index_meta_flight_dep_date (cost=0.00..2,487.79 rows=118,337 width=0) (actual time=11.303..11.303 rows=117,321 loops=1)

  • Index Cond: ((dep_date >= '2018-01-01 00:00:00'::timestamp without time zone) AND (dep_date <= '2018-12-31 23:59:59.999999'::timestamp without time zone))