explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fsDs

Settings
# exclusive inclusive rows x rows loops node
1. 0.454 104.716 ↓ 0.0 0 1

Insert on conversations (cost=1,974.44..1,977.43 rows=1 width=87) (actual time=104.716..104.716 rows=0 loops=1)

  • Conflict Resolution: UPDATE
  • Conflict Arbiter Indexes: conversations_pk
  • Tuples Inserted: 0
  • Conflicting Tuples: 2
2. 0.005 104.262 ↓ 2.0 2 1

Subquery Scan on proj (cost=1,974.44..1,977.43 rows=1 width=87) (actual time=99.084..104.262 rows=2 loops=1)

3. 13.445 104.257 ↓ 2.0 2 1

GroupAggregate (cost=1,974.44..1,977.42 rows=1 width=65) (actual time=99.081..104.257 rows=2 loops=1)

  • Group Key: c.member_guid, c.other_member_guid
4. 4.335 90.812 ↓ 8.9 5,956 1

Sort (cost=1,974.44..1,974.77 rows=668 width=81) (actual time=90.382..90.812 rows=5,956 loops=1)

  • Sort Key: c.member_guid, c.other_member_guid
  • Sort Method: quicksort Memory: 1030kB
5. 2.183 86.477 ↓ 8.9 5,956 1

Nested Loop Left Join (cost=2.80..1,968.17 rows=668 width=81) (actual time=0.241..86.477 rows=5,956 loops=1)

6. 0.007 0.282 ↓ 2.0 2 1

Nested Loop Left Join (cost=2.66..8.19 rows=1 width=64) (actual time=0.180..0.282 rows=2 loops=1)

7. 0.011 0.221 ↓ 2.0 2 1

Nested Loop Left Join (cost=2.55..5.87 rows=1 width=56) (actual time=0.153..0.221 rows=2 loops=1)

8. 0.025 0.112 ↓ 2.0 2 1

Bitmap Heap Scan on conversations c (cost=2.43..3.54 rows=1 width=40) (actual time=0.108..0.112 rows=2 loops=1)

  • Recheck Cond: (((member_guid = 'ccc900e0-e998-e2de-8bc8-a4f74a0fe8b3'::uuid) AND (other_member_guid = 'a8ac89f7-012c-b58a-84e0-227ca245c778'::uuid)) OR ((member_guid = 'a8ac89f7-012c-b58a-84e0-227ca245c778'::uuid) AND (other_member_guid = 'ccc900e0-e998-e2de-8bc8-a4f74a0fe8b3'::uuid)))
  • Heap Blocks: exact=1
9. 0.000 0.087 ↓ 0.0 0 1

BitmapOr (cost=2.43..2.43 rows=1 width=0) (actual time=0.087..0.087 rows=0 loops=1)

10. 0.054 0.054 ↑ 1.0 1 1

Bitmap Index Scan on conversations_pk (cost=0.00..1.22 rows=1 width=0) (actual time=0.054..0.054 rows=1 loops=1)

  • Index Cond: ((member_guid = 'ccc900e0-e998-e2de-8bc8-a4f74a0fe8b3'::uuid) AND (other_member_guid = 'a8ac89f7-012c-b58a-84e0-227ca245c778'::uuid))
11. 0.033 0.033 ↑ 1.0 1 1

Bitmap Index Scan on conversations_pk (cost=0.00..1.22 rows=1 width=0) (actual time=0.033..0.033 rows=1 loops=1)

  • Index Cond: ((member_guid = 'a8ac89f7-012c-b58a-84e0-227ca245c778'::uuid) AND (other_member_guid = 'ccc900e0-e998-e2de-8bc8-a4f74a0fe8b3'::uuid))
12. 0.098 0.098 ↑ 1.0 1 2

Index Scan using member_profiles_pk on member_profiles mp (cost=0.11..2.32 rows=1 width=32) (actual time=0.049..0.049 rows=1 loops=2)

  • Index Cond: (member_guid = c.other_member_guid)
13. 0.054 0.054 ↓ 0.0 0 2

Index Scan using member_blocked_pk on member_blocked mb (cost=0.11..2.32 rows=1 width=40) (actual time=0.027..0.027 rows=0 loops=2)

  • Index Cond: ((c.member_guid = member_guid) AND (c.other_member_guid = other_member_guid))
14. 84.012 84.012 ↓ 1.7 2,978 2

Index Scan using messages_member_legacy_message_id_uc on messages m (cost=0.14..1,942.66 rows=1,732 width=33) (actual time=0.061..42.006 rows=2,978 loops=2)

  • Index Cond: (c.member_guid = member_guid)