# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.024 | 31.757 | ↓ 1.3 | 90 | 1 |
→
Hash Join (cost=118.78..122.93 rows=70 width=259) (actual time=31.731..31.757 rows=90 loops=1)
|
2. | 0.011 | 0.011 | ↑ 1.0 | 90 | 1 |
→
Seq Scan on institutes (cost=0.00..3.90 rows=90 width=259) (actual time=0.006..0.011 rows=90 loops=1) |
3. | 0.013 | 31.722 | ↓ 1.3 | 90 | 1 |
→
Hash (cost=117.91..117.91 rows=70 width=16) (actual time=31.722..31.722 rows=90 loops=1)
|
4. | 1.158 | 31.709 | ↓ 1.3 | 90 | 1 |
→
HashAggregate (cost=116.51..117.21 rows=70 width=16) (actual time=31.700..31.709 rows=90 loops=1)
|
5. | 3.901 | 30.551 | ↓ 152.0 | 10,638 | 1 |
→
Nested Loop (cost=15.57..116.33 rows=70 width=16) (actual time=8.278..30.551 rows=10,638 loops=1)
|
6. | 0.010 | 0.010 | ↑ 1.0 | 90 | 1 |
→
Seq Scan on institutes institutes_1 (cost=0.00..3.90 rows=90 width=16) (actual time=0.001..0.010 rows=90 loops=1) |
7. | 2.161 | 26.640 | ↓ 164.2 | 657 | 90 |
→
Materialize (cost=15.57..106.14 rows=4 width=32) (actual time=0.001..0.296 rows=657 loops=90) |
8. | 6.073 | 24.479 | ↓ 164.2 | 657 | 1 |
→
Nested Loop (cost=15.57..106.12 rows=4 width=32) (actual time=0.123..24.479 rows=657 loops=1)
|
9. | 0.216 | 6.355 | ↓ 117.0 | 117 | 1 |
→
Nested Loop (cost=0.00..44.80 rows=1 width=64) (actual time=0.088..6.355 rows=117 loops=1) |
10. | 3.331 | 3.331 | ↓ 117.0 | 117 | 1 |
→
Seq Scan on biobank_acl bacl (cost=0.00..37.91 rows=1 width=32) (actual time=0.082..3.331 rows=117 loops=1)
|
11. | 2.808 | 2.808 | ↑ 1.0 | 1 | 117 |
→
Seq Scan on users_user_groups uug (cost=0.00..6.88 rows=1 width=32) (actual time=0.005..0.024 rows=1 loops=117)
|
12. | 8.775 | 12.051 | ↑ 1.0 | 425 | 117 |
→
Bitmap Heap Scan on registry_acl (cost=15.57..53.89 rows=425 width=32) (actual time=0.032..0.103 rows=425 loops=117)
|
13. | 3.276 | 3.276 | ↑ 1.0 | 425 | 117 |
→
Bitmap Index Scan on registry_acl_permission_idx (cost=0.00..15.47 rows=425 width=0) (actual time=0.028..0.028 rows=425 loops=117)
|
Planning time | : | 0.411 ms |
---|---|---|
Execution time | : | 31.799 ms |