explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EGiB

Settings
# exclusive inclusive rows x rows loops node
1. 19.377 67,773.889 ↑ 1.0 1 1

Aggregate (cost=2,990,353.24..2,990,353.25 rows=1 width=0) (actual time=67,773.889..67,773.889 rows=1 loops=1)

2. 10,692.378 67,754.512 ↓ 11.6 187,552 1

Hash Join (cost=8.31..2,990,312.68 rows=16,223 width=0) (actual time=0.195..67,754.512 rows=187,552 loops=1)

  • Hash Cond: ((t.begin_date_key)::bpchar = d.date_key)
3. 57,062.106 57,062.106 ↓ 1.0 59,375,793 1

Seq Scan on fact_task t (cost=0.00..2,767,482.92 rows=59,375,792 width=9) (actual time=0.008..57,062.106 rows=59,375,793 loops=1)

4. 0.003 0.028 ↑ 1.0 1 1

Hash (cost=8.30..8.30 rows=1 width=9) (actual time=0.028..0.028 rows=1 loops=1)

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

Index Scan using dim_date_date_short_idx on dim_date d (cost=0.28..8.30 rows=1 width=9) (actual time=0.024..0.025 rows=1 loops=1)

  • Index Cond: (date_short = '13/05/2019'::text)