explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AB6E

Settings
# exclusive inclusive rows x rows loops node
1. 38.518 215,803.186 ↑ 1.0 1 1

HashAggregate (cost=1,025,001.55..1,025,001.56 rows=1 width=67) (actual time=215,803.186..215,803.186 rows=1 loops=1)

  • Group Key: date.year4, date.year_month_number, date.year_month_abbreviation, date.date_short, date.date_key, dim_airline.airline_id, dim_airline.airline_name
2. 1,801.080 215,764.668 ↓ 850.2 45,059 1

Nested Loop (cost=10,511.80..1,025,000.62 rows=53 width=67) (actual time=117,712.153..215,764.668 rows=45,059 loops=1)

  • Join Filter: ((fact_task.begin_date_key)::bpchar = date.date_key)
  • Rows Removed by Join Filter: 15343056
3. 5.697 5.697 ↑ 1.0 1 1

Seq Scan on dim_date date (cost=0.00..166.05 rows=1 width=42) (actual time=0.332..5.697 rows=1 loops=1)

  • Filter: ((date_short = '13/05/2019'::text) AND (year_month_number = '2019-05'::text) AND (year4 = '2019'::text))
  • Rows Removed by Filter: 3659
4. 1,796.034 213,957.891 ↓ 78.7 15,388,115 1

Nested Loop (cost=10,511.80..1,022,389.91 rows=195,573 width=34) (actual time=2,006.421..213,957.891 rows=15,388,115 loops=1)

5. 2.519 2.519 ↑ 1.0 1 1

Seq Scan on dim_airline (cost=0.00..44.12 rows=1 width=33) (actual time=0.048..2.519 rows=1 loops=1)

  • Filter: (airline_id = 'EWG'::text)
  • Rows Removed by Filter: 1929
6. 210,157.972 212,159.338 ↓ 63.3 15,388,115 1

Bitmap Heap Scan on fact_task (cost=10,511.80..1,019,916.31 rows=242,948 width=17) (actual time=2,006.369..212,159.338 rows=15,388,115 loops=1)

  • Recheck Cond: (airline_key = (dim_airline.airline_key)::double precision)
  • Rows Removed by Index Recheck: 20812135
  • Filter: (hdp_section_id = ANY ('{AVI,BER,BEX,BRE,BRX,CGX,DRS,DUS,EGR,FRA,HAJ,HAM,HDQ,LEJ,MUC,SGS,TST,TXL,TXX}'::text[]))
  • Heap Blocks: exact=17702 lossy=1584458
7. 2,001.366 2,001.366 ↓ 50.0 18,434,493 1

Bitmap Index Scan on idx_fact_task_airline_key (cost=0.00..10,451.07 rows=368,333 width=0) (actual time=2,001.366..2,001.366 rows=18,434,493 loops=1)

  • Index Cond: (airline_key = (dim_airline.airline_key)::double precision)