explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Reu

Settings
# exclusive inclusive rows x rows loops node
1. 0.124 20,988.043 ↓ 18.0 18 1

Unique (cost=681.60..681.69 rows=1 width=1,136) (actual time=20,987.915..20,988.043 rows=18 loops=1)

2. 2.893 20,987.919 ↓ 64.0 64 1

Sort (cost=681.60..681.60 rows=1 width=1,136) (actual time=20,987.911..20,987.919 rows=64 loops=1)

  • Sort Key: main.name, main.id, main.password, main.comments, main.signature, main.emailaddress, main.freeformcontactinfo, main.organization, m
  • Sort Method: quicksort Memory: 57kB
3. 64.324 20,985.026 ↓ 64.0 64 1

Nested Loop (cost=1.83..681.59 rows=1 width=1,136) (actual time=1.680..20,985.026 rows=64 loops=1)

4. 162.314 163.455 ↓ 45,321.5 90,643 1

Nested Loop (cost=1.55..645.50 rows=2 width=1,140) (actual time=0.097..163.455 rows=90,643 loops=1)

  • -> Index Scan using cachedgroupmembers1 on cachedgroupmembers cachedgroupmembers_4 (cost=0.42..2.18 rows=7 width=8) (actual tim
5. 0.563 1.141 ↓ 36.0 36 1

Nested Loop (cost=1.13..643.25 rows=1 width=1,144) (actual time=0.057..1.141 rows=36 loops=1)

  • -> Index Scan using principals_pkey on principals principals_1 (cost=0.42..1.48 rows=1 width=4) (actual time=0.013..0.014
  • Index Cond: (memberid = principals_1.id)
  • Filter: (disabled = 0)
6. 0.578 0.578 ↓ 2.8 36 1

Nested Loop (cost=0.71..623.94 rows=13 width=1,140) (actual time=0.044..0.578 rows=36 loops=1)

  • -> Index Scan using users_pkey on users main (cost=0.29..5.22 rows=1 width=1,136) (actual time=0.008..0.010 rows=1 l
  • Index Cond: (id = main.id)
  • Filter: ((id <> 1) AND (disabled = 0) AND ((principaltype)::text = 'User'::text))
7. 0.000 0.000 ↓ 0.0

Index Only Scan using disgroumem on cachedgroupmembers cachedgroupmembers_2 (cost=0.42..189.79 rows=83 width=4) (actual rows= loops=)

  • Index Cond: ((groupid = 4) AND (disabled = 0))
  • Heap Fetches: 37
  • Index Cond: (id = cachedgroupmembers_2.memberid)
8. 20,757.247 20,757.247 ↓ 0.0 0 90,643

Index Only Scan using acl1 on acl acl_3 (cost=0.28..18.04 rows=1 width=4) (actual time=0.229..0.229 rows=0 loops=90,643)

  • Index Cond: ((principaltype = 'Group'::text) AND (principalid = cachedgroupmembers_4.groupid))
  • Filter: ((((rightname)::text = 'OwnTicket'::text) OR ((rightname)::text = 'SuperUser'::text)) AND ((((objecttype)::text = 'RT::Ti
  • Rows Removed by Filter: 0
  • Heap Fetches: 20,424
Total runtime : 20,988.297 ms