explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SXTH

Settings
# exclusive inclusive rows x rows loops node
1. 0.400 13.393 ↓ 0.0 0 1

Insert on conversations (cost=8.19..8.52 rows=1 width=87) (actual time=13.393..13.393 rows=0 loops=1)

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

Subquery Scan on proj (cost=8.19..8.52 rows=1 width=87) (actual time=8.805..12.993 rows=2 loops=1)

3. 12.659 12.989 ↓ 2.0 2 1

GroupAggregate (cost=8.19..8.51 rows=1 width=65) (actual time=8.803..12.989 rows=2 loops=1)

  • Group Key: c.member_guid, c.other_member_guid
4. 0.047 0.330 ↓ 2.0 2 1

Sort (cost=8.19..8.20 rows=1 width=64) (actual time=0.329..0.330 rows=2 loops=1)

  • Sort Key: c.member_guid, c.other_member_guid
  • Sort Method: quicksort Memory: 25kB
5. 0.004 0.283 ↓ 2.0 2 1

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

6. 0.005 0.207 ↓ 2.0 2 1

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

7. 0.022 0.150 ↓ 2.0 2 1

Bitmap Heap Scan on conversations c (cost=2.43..3.54 rows=1 width=40) (actual time=0.149..0.150 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
8. 0.002 0.128 ↓ 0.0 0 1

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

9. 0.083 0.083 ↑ 1.0 1 1

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

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

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

  • Index Cond: ((member_guid = 'a8ac89f7-012c-b58a-84e0-227ca245c778'::uuid) AND (other_member_guid = 'ccc900e0-e998-e2de-8bc8-a4f74a0fe8b3'::uuid))
11. 0.052 0.052 ↑ 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.026..0.026 rows=1 loops=2)

  • Index Cond: (member_guid = c.other_member_guid)
12. 0.072 0.072 ↓ 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.036..0.036 rows=0 loops=2)

  • Index Cond: ((c.member_guid = member_guid) AND (c.other_member_guid = other_member_guid))