explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SKrb

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 0.125 ↑ 42.0 1 1

Hash Join (cost=42.98..47.13 rows=42 width=259) (actual time=0.116..0.125 rows=1 loops=1)

  • Hash Cond: (institutes.id = institutes_1.id)
2. 0.010 0.010 ↑ 1.0 90 1

Seq Scan on institutes (cost=0.00..3.90 rows=90 width=259) (actual time=0.005..0.010 rows=90 loops=1)

3. 0.001 0.103 ↑ 42.0 1 1

Hash (cost=42.46..42.46 rows=42 width=16) (actual time=0.102..0.103 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
4. 0.004 0.102 ↑ 42.0 1 1

HashAggregate (cost=41.62..42.04 rows=42 width=16) (actual time=0.101..0.102 rows=1 loops=1)

  • Group Key: institutes_1.id
5. 0.000 0.098 ↑ 10.5 4 1

Nested Loop (cost=4.36..41.51 rows=42 width=16) (actual time=0.061..0.098 rows=4 loops=1)

  • Join Filter: ((registry_acl.institute_id IS NULL) OR (registry_acl.institute_id = institutes_1.id))
  • Rows Removed by Join Filter: 356
6. 0.008 0.008 ↑ 1.0 90 1

Seq Scan on institutes institutes_1 (cost=0.00..3.90 rows=90 width=16) (actual time=0.001..0.008 rows=90 loops=1)

7. 0.052 0.090 ↓ 2.0 4 90

Materialize (cost=4.36..34.92 rows=2 width=16) (actual time=0.000..0.001 rows=4 loops=90)

8. 0.002 0.038 ↓ 2.0 4 1

Nested Loop (cost=4.36..34.91 rows=2 width=16) (actual time=0.019..0.038 rows=4 loops=1)

9. 0.021 0.021 ↑ 1.0 1 1

Seq Scan on users_user_groups (cost=0.00..6.88 rows=1 width=16) (actual time=0.007..0.021 rows=1 loops=1)

  • Filter: (user_id = 'a342fa7e-4300-11e8-b98e-c708e2493908'::uuid)
  • Rows Removed by Filter: 309
10. 0.010 0.015 ↓ 2.0 4 1

Bitmap Heap Scan on registry_acl (cost=4.36..28.01 rows=2 width=32) (actual time=0.011..0.015 rows=4 loops=1)

  • Recheck Cond: (user_group_id = users_user_groups.user_group_id)
  • Filter: (permission = ANY ('{frm_create,bio_manage}'::text[]))
  • Rows Removed by Filter: 8
  • Heap Blocks: exact=3
11. 0.005 0.005 ↓ 1.1 12 1

Bitmap Index Scan on registry_acl_user_group_id_idx (cost=0.00..4.36 rows=11 width=0) (actual time=0.005..0.005 rows=12 loops=1)

  • Index Cond: (user_group_id = users_user_groups.user_group_id)
Planning time : 0.453 ms
Execution time : 0.161 ms