explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XqkH

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

XN Nested Loop DS_BCAST_INNER (cost=0.04..69,121,721.25 rows=62,496 width=36) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

XN Seq Scan on dim_kpi_v2 k (cost=0.02..7.50 rows=217 width=22) (actual rows= loops=)

  • Filter: (((fact_id = 1) AND ((kpi_type)::text = 'gpn'::text)) OR (hashed subplan))
3.          

SubPlan (forXN Seq Scan on dim_kpi_v2 k)

4. 0.000 0.000 ↓ 0.0

XN Result (cost=0.00..0.02 rows=1 width=4) (actual rows= loops=)

  • One-Time Filter: NULL::boolean
5. 0.000 0.000 ↓ 0.0

XN Subquery Scan etl_kpi_filter (cost=0.00..0.02 rows=1 width=4) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

XN Result (cost=0.00..0.01 rows=1 width=0) (actual rows= loops=)

  • One-Time Filter: false
7. 0.000 0.000 ↓ 0.0

XN Seq Scan on dim_unit u (cost=0.02..5.02 rows=288 width=14) (actual rows= loops=)

  • Filter: ((app_id = 1) OR (hashed subplan))
8.          

SubPlan (forXN Seq Scan on dim_unit u)

9. 0.000 0.000 ↓ 0.0

XN Result (cost=0.00..0.02 rows=1 width=22) (actual rows= loops=)

  • One-Time Filter: NULL::boolean
10. 0.000 0.000 ↓ 0.0

XN Subquery Scan etl_unit_filter (cost=0.00..0.02 rows=1 width=22) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

XN Result (cost=0.00..0.01 rows=1 width=0) (actual rows= loops=)

  • One-Time Filter: false