explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ngD

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

Gather (cost=1,000.42..23,511.97 rows=1,477 width=62) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..22,364.27 rows=615 width=62) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on cs_dim_rep_attributes csdr (cost=0.00..7,261.59 rows=9,053 width=29) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using dim_employee_pkey on dim_employee de (cost=0.42..1.67 rows=1 width=41) (actual rows= loops=)

  • Index Cond: (employee_rep_key = csdr.employee_rep_key)
  • Filter: ((current IS TRUE) AND (NOT is_terminated))