explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DNEt

Settings
# exclusive inclusive rows x rows loops node
1. 0.084 0.734 ↓ 45.8 366 1

Nested Loop (cost=1.14..95.81 rows=8 width=32) (actual time=0.121..0.734 rows=366 loops=1)

2. 0.012 0.130 ↓ 40.0 40 1

Nested Loop (cost=0.85..92.16 rows=1 width=24) (actual time=0.098..0.130 rows=40 loops=1)

3. 0.062 0.062 ↑ 13.0 1 1

Index Scan using i_emp_user_id on employee emp (cost=0.42..14.05 rows=13 width=16) (actual time=0.061..0.062 rows=1 loops=1)

  • Index Cond: (user_id = 3397025)
4. 0.056 0.056 ↓ 3.1 40 1

Index Scan using idx_emp_dep_eid_del on department_employee dep (cost=0.42..5.88 rows=13 width=16) (actual time=0.032..0.056 rows=40 loops=1)

  • Index Cond: (employee_id = emp.id)
5. 0.520 0.520 ↓ 1.5 9 40

Index Scan using department_position_dep_idx on department_position dp (cost=0.29..3.59 rows=6 width=16) (actual time=0.005..0.013 rows=9 loops=40)

  • Index Cond: (department_id = dep.department_id)
  • Filter: (deleted = 'N'::bpchar)
  • Rows Removed by Filter: 4