explain.depesz.com

PostgreSQL's explain analyze made readable

Result: khOF

Settings
# exclusive inclusive rows x rows loops node
1. 20.908 91,359.396 ↑ 1.0 1 1

Aggregate (cost=3,358,375.51..3,358,375.52 rows=1 width=0) (actual time=91,359.396..91,359.396 rows=1 loops=1)

2. 11,053.746 91,338.488 ↓ 11.6 187,552 1

Hash Join (cost=147.76..3,358,335.00 rows=16,203 width=0) (actual time=1.787..91,338.488 rows=187,552 loops=1)

  • Hash Cond: ((fact_task.begin_date_key)::bpchar = date.date_key)
3. 80,284.019 80,284.019 ↓ 1.0 59,375,793 1

Seq Scan on fact_task (cost=0.00..3,135,643.88 rows=59,301,688 width=9) (actual time=0.006..80,284.019 rows=59,375,793 loops=1)

4. 0.003 0.723 ↑ 1.0 1 1

Hash (cost=147.75..147.75 rows=1 width=9) (actual time=0.723..0.723 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.720 0.720 ↑ 1.0 1 1

Seq Scan on dim_date date (cost=0.00..147.75 rows=1 width=9) (actual time=0.269..0.720 rows=1 loops=1)

  • Filter: (date_short = '13/05/2019'::text)
  • Rows Removed by Filter: 3659