explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 36yg

Settings
# exclusive inclusive rows x rows loops node
1. 28.248 1,078.611 ↑ 1.0 1 1

Aggregate (cost=654,012.27..654,012.28 rows=1 width=8) (actual time=1,078.611..1,078.611 rows=1 loops=1)

2. 105.292 1,050.363 ↓ 3.7 87,982 1

Hash Join (cost=18,926.87..653,833.15 rows=23,883 width=7) (actual time=207.050..1,050.363 rows=87,982 loops=1)

  • Hash Cond: (e0_.meta_flight_fk = e1_.id)
3. 74.445 870.787 ↓ 3.2 320,724 1

Nested Loop (cost=4,005.23..638,293.25 rows=101,180 width=11) (actual time=132.147..870.787 rows=320,724 loops=1)

4. 0.021 0.021 ↑ 1.0 1 1

Index Scan using primary_unique_key_definition on key_definition p2_ (cost=0.28..8.30 rows=1 width=4) (actual time=0.018..0.021 rows=1 loops=1)

  • Index Cond: ((key_name)::text = 'FLIGHT_BLOCK_FB'::text)
5. 735.074 796.321 ↓ 1.5 320,724 1

Bitmap Heap Scan on computed_value e0_ (cost=4,004.95..636,147.69 rows=213,726 width=15) (actual time=132.124..796.321 rows=320,724 loops=1)

  • Recheck Cond: (key_fk = p2_.id)
  • Heap Blocks: exact=308057
6. 61.247 61.247 ↓ 1.5 320,724 1

Bitmap Index Scan on index_key_computed_value (cost=0.00..3,951.52 rows=213,726 width=0) (actual time=61.247..61.247 rows=320,724 loops=1)

  • Index Cond: (key_fk = p2_.id)
7. 23.931 74.284 ↑ 1.0 117,321 1

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

  • Buckets: 131072 Batches: 1 Memory Usage: 5149kB
8. 39.268 50.353 ↑ 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.706..50.353 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
9. 11.085 11.085 ↑ 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.085..11.085 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))