explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6sOb : Optimization for: plan #znaZ

Settings

Optimization path:

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

Limit (cost=21.20..21.21 rows=1 width=8) (actual time=0.259..0.260 rows=1 loops=1)

2. 0.003 0.259 ↑ 1.0 1 1

Aggregate (cost=21.20..21.21 rows=1 width=8) (actual time=0.259..0.259 rows=1 loops=1)

3. 0.001 0.256 ↑ 1.0 1 1

Nested Loop (cost=2.10..21.20 rows=1 width=8) (actual time=0.253..0.256 rows=1 loops=1)

4. 0.002 0.236 ↑ 1.0 1 1

Nested Loop (cost=1.83..20.90 rows=1 width=24) (actual time=0.233..0.236 rows=1 loops=1)

5. 0.003 0.210 ↑ 6.5 8 1

Nested Loop (cost=1.69..11.98 rows=52 width=24) (actual time=0.177..0.210 rows=8 loops=1)

6. 0.003 0.174 ↑ 1.7 3 1

Nested Loop (cost=1.41..7.76 rows=5 width=8) (actual time=0.155..0.174 rows=3 loops=1)

  • Join Filter: (administra1_.func_id = roles3_.role_id)
7. 0.002 0.127 ↓ 2.0 2 1

Nested Loop (cost=1.13..7.24 rows=1 width=16) (actual time=0.114..0.127 rows=2 loops=1)

8. 0.002 0.107 ↓ 2.0 2 1

Nested Loop (cost=0.99..5.56 rows=1 width=8) (actual time=0.098..0.107 rows=2 loops=1)

9. 0.033 0.033 ↓ 2.0 2 1

Index Only Scan using persons_func_pk on persons_func administra1_ (cost=0.29..1.81 rows=1 width=16) (actual time=0.031..0.033 rows=2 loops=1)

  • Index Cond: (person_id = 286,790)
  • Heap Fetches: 2
10. 0.002 0.072 ↑ 1.0 1 2

Nested Loop (cost=0.70..3.74 rows=1 width=8) (actual time=0.035..0.036 rows=1 loops=2)

11. 0.046 0.046 ↑ 1.0 1 2

Index Only Scan using persons_person_id_upper_first_name_upper_last_name_fbi on persons personimpl0_ (cost=0.29..1.80 rows=1 width=8) (actual time=0.023..0.023 rows=1 loops=2)

  • Index Cond: (person_id = 286,790)
  • Heap Fetches: 0
12. 0.024 0.024 ↑ 1.0 1 2

Index Only Scan using recipients_rid_when_updated_desc_pidx on recipients personimpl0_1_ (cost=0.41..1.93 rows=1 width=8) (actual time=0.012..0.012 rows=1 loops=2)

  • Index Cond: (recipient_id = 286,790)
  • Heap Fetches: 0
13. 0.018 0.018 ↑ 1.0 1 2

Index Only Scan using role_pk on role defaultadm2_ (cost=0.14..1.66 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=2)

  • Index Cond: (role_id = administra1_.func_id)
  • Heap Fetches: 1
14. 0.044 0.044 ↑ 2.5 2 2

Index Only Scan using role_func_pk on role_func roles3_ (cost=0.28..0.46 rows=5 width=16) (actual time=0.022..0.022 rows=2 loops=2)

  • Index Cond: (role_id = defaultadm2_.role_id)
  • Heap Fetches: 0
15. 0.033 0.033 ↑ 6.0 3 3

Index Only Scan using org_func_perms_pk on org_func_perms permission5_ (cost=0.28..0.66 rows=18 width=16) (actual time=0.010..0.011 rows=3 loops=3)

  • Index Cond: (org_func_id = roles3_.org_func_id)
  • Heap Fetches: 0
16. 0.024 0.024 ↓ 0.0 0 8

Index Scan using perms_pk on perms permission6_ (cost=0.15..0.17 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=8)

  • Index Cond: (perm_id = permission5_.perm_id)
  • Filter: ((name)::text = 'ability.act.OverrideSamlSsoLogin'::text)
  • Rows Removed by Filter: 1
17. 0.019 0.019 ↑ 1.0 1 1

Index Only Scan using org_func_pk on org_func orgroleimp4_ (cost=0.27..0.29 rows=1 width=8) (actual time=0.019..0.019 rows=1 loops=1)

  • Index Cond: (org_func_id = roles3_.org_func_id)
  • Heap Fetches: 0
Planning time : 10.219 ms
Execution time : 0.433 ms