explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BN7UC

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

Result (cost=21.09..38.58 rows=1 width=32) (actual time=0.039..0.039 rows=0 loops=1)

  • One-Time Filter: (NOT $0)
2.          

Initplan (for Result)

3. 0.015 0.039 ↑ 1.0 1 1

Hash Join (cost=13.64..20.79 rows=1 width=0) (actual time=0.039..0.039 rows=1 loops=1)

  • Hash Cond: (person_to_person_type.person_type_id = person_type.id)
4. 0.018 0.018 ↓ 1.0 157 1

Seq Scan on person_to_person_type (cost=0.00..6.56 rows=156 width=16) (actual time=0.006..0.018 rows=157 loops=1)

5. 0.002 0.006 ↑ 1.0 1 1

Hash (cost=13.62..13.62 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on person_type (cost=0.00..13.62 rows=1 width=16) (actual time=0.003..0.004 rows=1 loops=1)

  • Filter: (base_type = 'INTERNAL'::text)
  • Rows Removed by Filter: 9
7. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.29..17.79 rows=1 width=32) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.15..9.61 rows=1 width=48) (never executed)

  • Join Filter: (organizational_unit.id = person_assignment.organizational_unit_id)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_organizational_unit_state on organizational_unit (cost=0.15..8.17 rows=1 width=32) (never executed)

  • Index Cond: (state = 'ACTIVE'::text)
10. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_assignment (cost=0.00..1.44 rows=1 width=32) (never executed)

  • Filter: ((state = 'ACTIVE'::text) AND (person_id = '8e459ecd-2208-44b9-836a-b9bbf182ec03'::uuid))
11. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_organizational_hierarchy on organizational_hierarchy (cost=0.15..8.17 rows=1 width=16) (never executed)

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