#	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)


QUERY PLAN
Nested Loop  (cost=1.57..97.27 rows=8 width=32) (actual time=0.056..0.056 rows=0 loops=1)
  ->  Nested Loop  (cost=1.28..93.62 rows=1 width=24) (actual time=0.056..0.056 rows=0 loops=1)
        ->  Nested Loop  (cost=0.85..92.16 rows=1 width=32) (actual time=0.056..0.056 rows=0 loops=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)
              ->  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)
        ->  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
  ->  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)

Per node type stats

node type	count	sum of times	% of query
Index Only Scan	1	0.000 ms	0.0 %
Index Scan	3	0.055 ms	98.2 %
Nested Loop	3	0.001 ms	1.8 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
app_user	1	0.000 ms	0.0 %
Index Only Scan	1	0.000 ms	0.0 %
department_employee	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
department_position	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
employee	1	0.055 ms	98.2 %
Index Scan	1	0.055 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3Cr2

Color mode:

Visible columns:

Per node type stats

Per table stats