explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sKb6

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

XN Hash Join DS_BCAST_INNER (cost=7.65..773,348,637,062.06 rows=48,136 width=308) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

XN Hash Join DS_BCAST_INNER (cost=4.39..772,730,900,014.39 rows=5,245,420,435 width=269) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

XN Hash (cost=2.58..2.58 rows=1 width=330) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_ALL_NONE (cost=1.67..2.58 rows=1 width=330) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

XN Seq Scan on elms_snsr_gpn_map_v2 gpn (cost=0.00..0.88 rows=1 width=421) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

XN Hash (cost=1.39..1.39 rows=112 width=23) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

XN Seq Scan on dim_kpi_v2 k (cost=0.00..1.39 rows=112 width=23) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

XN Hash (cost=3.25..3.25 rows=1 width=130) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

XN Seq Scan on fact_event (cost=0.00..3.25 rows=1 width=130) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

XN Hash (cost=1.45..1.45 rows=145 width=29) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

XN Seq Scan on uom_cnvs_map uom (cost=0.00..1.45 rows=145 width=29) (actual rows= loops=)