explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2vjr

Settings
# exclusive inclusive rows x rows loops node
1. 0.086 40,084.486 ↓ 18.0 18 1

Unique (cost=796.60..796.67 rows=1 width=350) (actual time=40,084.374..40,084.486 rows=18 loops=1)

2. 0.370 40,084.400 ↓ 28.0 28 1

Sort (cost=796.60..796.60 rows=1 width=350) (actual time=40,084.370..40,084.400 rows=28 loops=1)

  • Sort Key: main.name, main.id, main.password, main.comments, main.signature, main.emailaddress, main.freeformcontactinfo, main.organization, main.realname, main.nickname, main.lang, main.gecos, main.homephone, main.workphone, main.mobilephone, main.pagerphone, main.address1, main.address2, main.city, main.state, main.zip, main.country, main.timezone, main.creator, main.created, main.lastupdatedby, main.lastupdated, main.authtoken, main.smimecertificate
  • Sort Method: quicksort Memory: 41kB
3. 2,335.323 40,084.030 ↓ 28.0 28 1

Nested Loop (cost=1.99..796.59 rows=1 width=350) (actual time=0.520..40,084.030 rows=28 loops=1)

4. 1,997.580 4,194.667 ↓ 430,180.0 860,360 1

Nested Loop (cost=1.71..789.86 rows=2 width=354) (actual time=0.087..4,194.667 rows=860,360 loops=1)

5. 0.537 4.156 ↓ 117.0 117 1

Nested Loop (cost=1.28..788.94 rows=1 width=358) (actual time=0.064..4.156 rows=117 loops=1)

6. 0.773 2.191 ↓ 8.5 119 1

Nested Loop (cost=0.85..780.03 rows=14 width=354) (actual time=0.051..2.191 rows=119 loops=1)

7. 0.458 0.458 ↑ 1.2 120 1

Index Scan using disgroumem on cachedgroupmembers cachedgroupmembers_2 (cost=0.43..185.90 rows=142 width=4) (actual time=0.022..0.458 rows=120 loops=1)

  • Index Cond: (groupid = 4)
  • Filter: (disabled = 0)
8. 0.960 0.960 ↑ 1.0 1 120

Index Scan using users_pkey on users main (cost=0.42..4.18 rows=1 width=350) (actual time=0.008..0.008 rows=1 loops=120)

  • Index Cond: (id = cachedgroupmembers_2.memberid)
9. 1.428 1.428 ↑ 1.0 1 119

Index Scan using principals_pkey on principals principals_1 (cost=0.43..0.64 rows=1 width=4) (actual time=0.012..0.012 rows=1 loops=119)

  • Index Cond: (id = main.id)
  • Filter: ((id <> 1) AND (disabled = 0) AND ((principaltype)::text = 'User'::text))
  • Rows Removed by Filter: 0
10. 2,192.931 2,192.931 ↓ 3,677.0 7,354 117

Index Scan using cachedgroupmembers4 on cachedgroupmembers cachedgroupmembers_4 (cost=0.43..0.90 rows=2 width=8) (actual time=0.012..18.743 rows=7,354 loops=117)

  • Index Cond: (memberid = principals_1.id)
  • Filter: (disabled = 0)
  • Rows Removed by Filter: 0
11. 33,554.040 33,554.040 ↓ 0.0 0 860,360

Index Only Scan using acl1 on acl acl_3 (cost=0.28..3.35 rows=1 width=4) (actual time=0.039..0.039 rows=0 loops=860,360)

  • Index Cond: ((rightname = 'OwnTicket'::text) AND (principaltype = 'Group'::text) AND (principalid = cachedgroupmembers_4.groupid))
  • Filter: ((((objecttype)::text = 'RT::Queue'::text) AND (objectid = 19)) OR (((objecttype)::text = 'RT::System'::text) AND (objectid = 1)))
  • Rows Removed by Filter: 0
  • Heap Fetches: 0
Planning time : 52.387 ms
Execution time : 40,084.660 ms