explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rjMI

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 1,446.683 ↓ 3.0 3 1

Unique (cost=996.94..996.95 rows=1 width=40) (actual time=1,446.677..1,446.683 rows=3 loops=1)

2. 0.017 1,446.677 ↓ 4.0 4 1

Sort (cost=996.94..996.95 rows=1 width=40) (actual time=1,446.675..1,446.677 rows=4 loops=1)

  • Sort Key: c.objectid, c.axis, c."timestamp" DESC, c.seqnumber DESC
  • Sort Method: quicksort Memory: 25kB
3. 240.993 1,446.660 ↓ 4.0 4 1

Hash Semi Join (cost=5.12..996.93 rows=1 width=40) (actual time=1.580..1,446.660 rows=4 loops=1)

  • Hash Cond: (c.objectid = (objectid.objectid)::uuid)
4. 500.558 1,205.658 ↓ 672.9 645,359 1

Nested Loop (cost=2.87..991.92 rows=959 width=40) (actual time=0.039..1,205.658 rows=645,359 loops=1)

5. 0.005 0.019 ↑ 1.0 1 1

HashAggregate (cost=2.44..2.45 rows=1 width=16) (actual time=0.017..0.019 rows=1 loops=1)

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

  • Index Cond: (rootid = 'ac37072a-dd25-4d7f-8cd9-7ff12b0b5e34'::uuid)
  • Heap Fetches: 1
7. 705.081 705.081 ↓ 672.9 645,359 1

Index Scan using conversationlog_groupid on conversationlog c (cost=0.43..979.88 rows=959 width=56) (actual time=0.020..705.081 rows=645,359 loops=1)

  • Index Cond: (groupid = securitygroup_levels_materialised.id)
8. 0.003 0.009 ↑ 100.0 1 1

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

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

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