explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CIdF

Settings
# exclusive inclusive rows x rows loops node
1. 0.169 44,614.057 ↓ 35.0 35 1

Unique (cost=116.47..116.55 rows=1 width=342) (actual time=44,613.837..44,614.057 rows=35 loops=1)

2. 0.794 44,613.888 ↓ 53.0 53 1

Sort (cost=116.47..116.47 rows=1 width=342) (actual time=44,613.833..44,613.888 rows=53 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: 51kB
3. 17,838.587 44,613.094 ↓ 53.0 53 1

Nested Loop (cost=8.10..116.46 rows=1 width=342) (actual time=7,811.340..44,613.094 rows=53 loops=1)

  • Join Filter: (cachedgroupmembers_4.groupid = acl_3.principalid)
  • Rows Removed by Join Filter: 12905347
4. 0.623 0.752 ↓ 3.8 15 1

Bitmap Heap Scan on acl acl_3 (cost=6.39..60.11 rows=4 width=4) (actual time=0.190..0.752 rows=15 loops=1)

  • Recheck Cond: ((((rightname)::text = 'OwnTicket'::text) AND ((principaltype)::text = 'Group'::text)) OR (((rightname)::text = 'SuperUser'::text) AND ((principaltype)::text = 'Group'::text)))
  • Filter: ((((objecttype)::text = 'RT::Queue'::text) AND (objectid = 55)) OR (((objecttype)::text = 'RT::System'::text) AND (objectid = 1)))
  • Rows Removed by Filter: 192
  • Heap Blocks: exact=48
5. 0.004 0.129 ↓ 0.0 0 1

BitmapOr (cost=6.39..6.39 rows=208 width=0) (actual time=0.128..0.129 rows=0 loops=1)

6. 0.078 0.078 ↑ 1.0 199 1

Bitmap Index Scan on acl1 (cost=0.00..4.92 rows=201 width=0) (actual time=0.077..0.078 rows=199 loops=1)

  • Index Cond: (((rightname)::text = 'OwnTicket'::text) AND ((principaltype)::text = 'Group'::text))
7. 0.047 0.047 ↓ 1.1 8 1

Bitmap Index Scan on acl1 (cost=0.00..1.46 rows=7 width=0) (actual time=0.046..0.047 rows=8 loops=1)

  • Index Cond: (((rightname)::text = 'SuperUser'::text) AND ((principaltype)::text = 'Group'::text))
8. 23,782.634 26,773.755 ↓ 430,180.0 860,360 15

Materialize (cost=1.71..56.24 rows=2 width=346) (actual time=0.022..1,784.917 rows=860,360 loops=15)

9. 1,946.018 2,991.121 ↓ 430,180.0 860,360 1

Nested Loop (cost=1.71..56.23 rows=2 width=346) (actual time=0.200..2,991.121 rows=860,360 loops=1)

10. 0.595 5.675 ↓ 117.0 117 1

Nested Loop (cost=1.28..53.24 rows=1 width=350) (actual time=0.153..5.675 rows=117 loops=1)

11. 0.667 3.910 ↓ 58.5 117 1

Nested Loop (cost=0.86..52.31 rows=2 width=8) (actual time=0.117..3.910 rows=117 loops=1)

12. 0.243 0.243 ↓ 6.3 120 1

Index Only Scan using disgroumem on cachedgroupmembers cachedgroupmembers_2 (cost=0.43..1.91 rows=19 width=4) (actual time=0.046..0.243 rows=120 loops=1)

  • Index Cond: ((groupid = 4) AND (disabled = 0))
  • Heap Fetches: 0
13. 3.000 3.000 ↑ 1.0 1 120

Index Scan using principals_pkey on principals principals_1 (cost=0.43..2.65 rows=1 width=4) (actual time=0.025..0.025 rows=1 loops=120)

  • Index Cond: (id = cachedgroupmembers_2.memberid)
  • Filter: ((id <> 1) AND (disabled = 0) AND ((principaltype)::text = 'User'::text))
  • Rows Removed by Filter: 0
14. 1.170 1.170 ↑ 1.0 1 117

Index Scan using users_pkey on users main (cost=0.42..0.47 rows=1 width=342) (actual time=0.010..0.010 rows=1 loops=117)

  • Index Cond: (id = principals_1.id)
15. 1,039.428 1,039.428 ↓ 89.7 7,354 117

Index Only Scan using cachedgroupmembers4 on cachedgroupmembers cachedgroupmembers_4 (cost=0.43..2.16 rows=82 width=8) (actual time=0.015..8.884 rows=7,354 loops=117)

  • Index Cond: ((memberid = principals_1.id) AND (disabled = 0))
  • Heap Fetches: 0
Planning time : 6.612 ms
Execution time : 44,643.566 ms