explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nm5R

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.124 ↑ 1.0 1 1

Nested Loop (cost=0.29..17.79 rows=1 width=32) (actual time=0.050..0.124 rows=1 loops=1)

2. 0.005 0.120 ↑ 1.0 1 1

Nested Loop (cost=0.15..9.61 rows=1 width=48) (actual time=0.047..0.120 rows=1 loops=1)

  • Join Filter: (organizational_unit.id = person_assignment.organizational_unit_id)
  • Rows Removed by Join Filter: 25
3. 0.011 0.011 ↓ 26.0 26 1

Index Scan using idx_organizational_unit_state on organizational_unit (cost=0.15..8.17 rows=1 width=32) (actual time=0.009..0.011 rows=26 loops=1)

  • Index Cond: (state = 'ACTIVE'::text)
4. 0.104 0.104 ↑ 1.0 1 26

Seq Scan on person_assignment (cost=0.00..1.44 rows=1 width=32) (actual time=0.003..0.004 rows=1 loops=26)

  • Filter: ((state = 'ACTIVE'::text) AND (person_id = '8e459ecd-2208-44b9-836a-b9bbf182ec03'::uuid))
  • Rows Removed by Filter: 28
5. 0.003 0.003 ↑ 1.0 1 1

Index Scan using pk_organizational_hierarchy on organizational_hierarchy (cost=0.15..8.17 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (id = organizational_unit.organizational_hierarchy_id)
  • Filter: (state = 'ACTIVE'::text)
Planning time : 0.174 ms
Execution time : 0.147 ms