explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3Cr2

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

Nested Loop (cost=1.57..97.27 rows=8 width=32) (actual time=0.056..0.056 rows=0 loops=1)

2. 0.000 0.056 ↓ 0.0 0 1

Nested Loop (cost=1.28..93.62 rows=1 width=24) (actual time=0.056..0.056 rows=0 loops=1)

3. 0.001 0.056 ↓ 0.0 0 1

Nested Loop (cost=0.85..92.16 rows=1 width=32) (actual time=0.056..0.056 rows=0 loops=1)

4. 0.055 0.055 ↓ 0.0 0 1

Index Scan using i_emp_user_id on employee emp (cost=0.42..14.05 rows=13 width=24) (actual time=0.055..0.055 rows=0 loops=1)

  • Index Cond: (user_id = 299)
5. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_emp_dep_eid_del on department_employee dep (cost=0.42..5.88 rows=13 width=16) (never executed)

  • Index Cond: (employee_id = emp.id)
6. 0.000 0.000 ↓ 0.0 0

Index Only Scan using app_user_pkey on app_user au (cost=0.43..1.45 rows=1 width=8) (never executed)

  • Index Cond: (id = 299)
  • Heap Fetches: 0
7. 0.000 0.000 ↓ 0.0 0

Index Scan using department_position_dep_idx on department_position dp (cost=0.29..3.59 rows=6 width=16) (never executed)

  • Index Cond: (department_id = dep.department_id)
  • Filter: (deleted = 'N'::bpchar)