explain.depesz.com

PostgreSQL's explain analyze made readable

Result: znaZ

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.007 0.616 ↑ 1.0 1 1

Limit (cost=22.70..22.71 rows=1 width=8) (actual time=0.616..0.616 rows=1 loops=1)

2. 0.008 0.609 ↑ 1.0 1 1

Aggregate (cost=22.70..22.71 rows=1 width=8) (actual time=0.609..0.609 rows=1 loops=1)

3. 0.001 0.601 ↑ 1.0 1 1

Nested Loop (cost=2.10..22.70 rows=1 width=8) (actual time=0.599..0.601 rows=1 loops=1)

4. 0.000 0.576 ↑ 1.0 1 1

Nested Loop (cost=1.83..22.40 rows=1 width=24) (actual time=0.574..0.576 rows=1 loops=1)

5. 0.003 0.530 ↑ 6.5 8 1

Nested Loop (cost=1.69..13.48 rows=52 width=24) (actual time=0.455..0.530 rows=8 loops=1)

6. 0.003 0.449 ↑ 1.7 3 1

Nested Loop (cost=1.41..9.26 rows=5 width=8) (actual time=0.409..0.449 rows=3 loops=1)

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

Nested Loop (cost=1.13..8.74 rows=1 width=16) (actual time=0.363..0.384 rows=2 loops=1)

8. 0.003 0.344 ↓ 2.0 2 1

Nested Loop (cost=0.99..7.06 rows=1 width=8) (actual time=0.329..0.344 rows=2 loops=1)

9. 0.187 0.187 ↓ 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.180..0.187 rows=2 loops=1)

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

Nested Loop (cost=0.70..5.25 rows=1 width=8) (actual time=0.076..0.077 rows=1 loops=2)

11. 0.078 0.078 ↑ 1.0 1 2

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

  • Index Cond: (person_id = 286,790)
  • Heap Fetches: 2
12. 0.076 0.076 ↑ 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.037..0.038 rows=1 loops=2)

  • Index Cond: (recipient_id = 286,790)
  • Heap Fetches: 0
13. 0.038 0.038 ↑ 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.019..0.019 rows=1 loops=2)

  • Index Cond: (role_id = administra1_.func_id)
  • Heap Fetches: 1
14. 0.062 0.062 ↑ 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.031..0.031 rows=2 loops=2)

  • Index Cond: (role_id = defaultadm2_.role_id)
  • Heap Fetches: 0
15. 0.078 0.078 ↑ 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.023..0.026 rows=3 loops=3)

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

Index Scan using perms_pk on perms permission6_ (cost=0.15..0.17 rows=1 width=8) (actual time=0.006..0.006 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.024 0.024 ↑ 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.024..0.024 rows=1 loops=1)

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