explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KFht

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 1,786.275 ↑ 1.0 3 1

Unique (cost=660.44..660.47 rows=3 width=40) (actual time=1,786.266..1,786.275 rows=3 loops=1)

2. 0.032 1,786.266 ↑ 1.0 3 1

Sort (cost=660.44..660.45 rows=3 width=40) (actual time=1,786.264..1,786.266 rows=3 loops=1)

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

Hash Semi Join (cost=4.86..660.42 rows=3 width=40) (actual time=361.612..1,786.234 rows=3 loops=1)

  • Hash Cond: (c.objectid = objectid.objectid)
4. 754.490 1,422.717 ↓ 15.9 466,832 1

Nested Loop (cost=2.61..581.00 rows=29,384 width=40) (actual time=0.073..1,422.717 rows=466,832 loops=1)

5. 0.006 0.055 ↑ 1.0 1 1

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

6. 0.005 0.023 ↑ 3.0 1 1

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

  • Group Key: securitygroup_levels_materialised.id
7. 0.018 0.018 ↑ 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.016..0.018 rows=1 loops=1)

  • Index Cond: (rootid = '68345355-6d50-4abb-9d27-649b8d98ac31'::uuid)
  • Heap Fetches: 0
8. 0.026 0.026 ↑ 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.024..0.026 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. 668.172 668.172 ↓ 67.2 466,832 1

Index Scan using conversationlog_groupid on conversationlog c (cost=0.56..504.23 rows=6,947 width=56) (actual time=0.021..668.172 rows=466,832 loops=1)

  • Index Cond: (groupid = acl.groupid)
10. 0.006 0.015 ↑ 100.0 1 1

Hash (cost=1.00..1.00 rows=100 width=16) (actual time=0.014..0.015 rows=1 loops=1)

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

Function Scan on unnest objectid (cost=0.00..1.00 rows=100 width=16) (actual time=0.007..0.009 rows=1 loops=1)

Planning time : 1.562 ms
Execution time : 1,786.392 ms