explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W9xi

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 10,754.527 ↑ 1.0 3 1

Unique (cost=667.80..667.82 rows=3 width=40) (actual time=10,754.516..10,754.527 rows=3 loops=1)

2. 0.068 10,754.517 ↑ 1.0 3 1

Sort (cost=667.80..667.80 rows=3 width=40) (actual time=10,754.514..10,754.517 rows=3 loops=1)

  • Sort Key: c.objectid, c.axis, c."timestamp" DESC, c.seqnumber DESC
  • Sort Method: quicksort Memory: 25kB
3. 1,923.450 10,754.449 ↑ 1.0 3 1

Hash Semi Join (cost=4.86..667.77 rows=3 width=40) (actual time=2,810.073..10,754.449 rows=3 loops=1)

  • Hash Cond: (c.objectid = (objectid.objectid)::uuid)
4. 3,942.596 8,830.974 ↓ 15.9 466,826 1

Nested Loop (cost=2.61..581.00 rows=29,384 width=40) (actual time=0.277..8,830.974 rows=466,826 loops=1)

5. 0.006 0.215 ↑ 1.0 1 1

Nested Loop (cost=2.05..7.30 rows=1 width=32) (actual time=0.190..0.215 rows=1 loops=1)

6. 0.007 0.078 ↑ 3.0 1 1

HashAggregate (cost=1.48..1.51 rows=3 width=16) (actual time=0.076..0.078 rows=1 loops=1)

  • Group Key: securitygroup_levels_materialised.id
7. 0.071 0.071 ↑ 3.0 1 1

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

  • Index Cond: (rootid = '68345355-6d50-4abb-9d27-649b8d98ac31'::uuid)
  • Heap Fetches: 0
8. 0.131 0.131 ↑ 1.0 1 1

Index Only Scan using accesslist_idx on accesslist acl (cost=0.56..1.92 rows=1 width=16) (actual time=0.110..0.131 rows=1 loops=1)

  • Index Cond: ((userid = '6d4ad353-a0d0-4b3f-b26b-d0ab5c00ecbb'::uuid) AND (groupid = securitygroup_levels_materialised.id) AND (operationid = '10'::bigint))
  • Heap Fetches: 1
9. 4,888.163 4,888.163 ↓ 67.2 466,826 1

Index Scan using conversationlog_groupid on conversationlog c (cost=0.56..504.23 rows=6,947 width=56) (actual time=0.082..4,888.163 rows=466,826 loops=1)

  • Index Cond: (groupid = acl.groupid)
10. 0.012 0.025 ↑ 100.0 1 1

Hash (cost=1.00..1.00 rows=100 width=32) (actual time=0.024..0.025 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.013 0.013 ↑ 100.0 1 1

Function Scan on unnest objectid (cost=0.00..1.00 rows=100 width=32) (actual time=0.011..0.013 rows=1 loops=1)

Planning time : 4.186 ms
Execution time : 10,754.738 ms