explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XwhI

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.027 62,659.757 ↓ 3.0 3 1

Unique (cost=988.02..988.03 rows=1 width=40) (actual time=62,659.729..62,659.757 rows=3 loops=1)

2. 0.079 62,659.730 ↓ 4.0 4 1

Sort (cost=988.02..988.03 rows=1 width=40) (actual time=62,659.726..62,659.730 rows=4 loops=1)

  • Sort Key: c.objectid, c.axis, c."timestamp" DESC, c.seqnumber DESC
  • Sort Method: quicksort Memory: 25kB
3. 17,610.995 62,659.651 ↓ 4.0 4 1

Nested Loop Semi Join (cost=3.43..988.01 rows=1 width=40) (actual time=1.085..62,659.651 rows=4 loops=1)

  • Join Filter: (c.objectid = objectid.objectid)
  • Rows Removed by Join Filter: 644226
4. 14,420.819 32,164.056 ↓ 644,230.0 644,230 1

Nested Loop (cost=3.43..985.76 rows=1 width=40) (actual time=0.267..32,164.056 rows=644,230 loops=1)

5. 0.006 0.191 ↑ 1.0 1 1

Nested Loop (cost=2.99..5.03 rows=1 width=32) (actual time=0.175..0.191 rows=1 loops=1)

6. 0.008 0.077 ↑ 1.0 1 1

HashAggregate (cost=2.44..2.45 rows=1 width=16) (actual time=0.075..0.077 rows=1 loops=1)

  • Group Key: securitygroup_levels_materialised.id
7. 0.069 0.069 ↑ 1.0 1 1

Index Only Scan using slm_rootid_id on securitygroup_levels_materialised (cost=0.42..2.44 rows=1 width=16) (actual time=0.067..0.069 rows=1 loops=1)

  • Index Cond: (rootid = 'ac37072a-dd25-4d7f-8cd9-7ff12b0b5e34'::uuid)
  • Heap Fetches: 1
8. 0.108 0.108 ↑ 1.0 1 1

Index Only Scan using accesslist_unique_constraint on accesslist acl (cost=0.56..2.58 rows=1 width=16) (actual time=0.096..0.108 rows=1 loops=1)

  • Index Cond: ((operationid = '10'::bigint) AND (groupid = securitygroup_levels_materialised.id) AND (userid = 'b7230297-2955-4b65-b87d-d013d340ba94'::uuid))
  • Heap Fetches: 0
9. 17,743.046 17,743.046 ↓ 671.8 644,230 1

Index Scan using conversationlog_groupid on conversationlog c (cost=0.43..971.14 rows=959 width=56) (actual time=0.088..17,743.046 rows=644,230 loops=1)

  • Index Cond: (groupid = acl.groupid)
10. 12,884.600 12,884.600 ↑ 100.0 1 644,230

Function Scan on unnest objectid (cost=0.00..1.00 rows=100 width=16) (actual time=0.011..0.020 rows=1 loops=644,230)

Planning time : 4.396 ms
Execution time : 62,659.962 ms