explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6QKS

Settings
# exclusive inclusive rows x rows loops node
1. 52.385 179.267 ↑ 3.3 68 1

GroupAggregate (cost=25,039.65..25,052.46 rows=222 width=172) (actual time=117.476..179.267 rows=68 loops=1)

  • Group Key: fud.property_key
2. 55.815 126.882 ↓ 347.3 77,441 1

Sort (cost=25,039.65..25,040.21 rows=223 width=77) (actual time=115.821..126.882 rows=77,441 loops=1)

  • Sort Key: fud.property_key
  • Sort Method: external merge Disk: 4616kB
3. 49.686 71.067 ↓ 347.3 77,441 1

Hash Join (cost=3,107.02..25,030.95 rows=223 width=77) (actual time=7.687..71.067 rows=77,441 loops=1)

  • Hash Cond: (fud.client_key = dc.client_key)
4. 14.318 21.366 ↓ 1.0 77,441 1

Bitmap Heap Scan on fact_unit_daily fud (cost=3,098.72..24,735.68 rows=75,931 width=81) (actual time=7.659..21.366 rows=77,441 loops=1)

  • Recheck Cond: ((date_key >= '2019-06-01'::date) AND (date_key <= '2019-06-30'::date))
  • Heap Blocks: exact=4270
5. 7.048 7.048 ↓ 1.0 77,441 1

Bitmap Index Scan on pk_fact_unit_daily (cost=0.00..3,079.73 rows=75,931 width=0) (actual time=7.048..7.048 rows=77,441 loops=1)

  • Index Cond: ((date_key >= '2019-06-01'::date) AND (date_key <= '2019-06-30'::date))
6. 0.004 0.015 ↑ 1.0 1 1

Hash (cost=8.29..8.29 rows=1 width=4) (actual time=0.015..0.015 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.011 0.011 ↑ 1.0 1 1

Index Scan using dim_client_client_id on dim_client dc (cost=0.27..8.29 rows=1 width=4) (actual time=0.010..0.011 rows=1 loops=1)

  • Index Cond: (client_id = '15077'::text)
Planning time : 0.277 ms