explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CpbA

Settings
# exclusive inclusive rows x rows loops node
1. 0.180 63.455 ↓ 0.0 0 1

Insert on conversations (cost=32.19..34.23 rows=1 width=87) (actual time=63.455..63.455 rows=0 loops=1)

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

Subquery Scan on proj (cost=32.19..34.23 rows=1 width=87) (actual time=33.309..63.275 rows=2 loops=1)

3. 63.234 63.265 ↓ 2.0 2 1

GroupAggregate (cost=32.19..34.22 rows=1 width=65) (actual time=33.302..63.265 rows=2 loops=1)

  • Group Key: c.member_guid, c.other_member_guid
4. 0.010 0.031 ↓ 2.0 2 1

Sort (cost=32.19..32.20 rows=1 width=64) (actual time=0.027..0.031 rows=2 loops=1)

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

Nested Loop Left Join (cost=9.01..32.18 rows=1 width=64) (actual time=0.019..0.021 rows=2 loops=1)

6. 0.002 0.015 ↓ 2.0 2 1

Nested Loop Left Join (cost=8.86..23.99 rows=1 width=56) (actual time=0.013..0.015 rows=2 loops=1)

7. 0.003 0.009 ↓ 2.0 2 1

Bitmap Heap Scan on conversations c (cost=8.58..15.69 rows=1 width=40) (actual time=0.008..0.009 rows=2 loops=1)

  • Recheck Cond: ((other_member_guid = '957a8d87-430a-946f-725a-4c9c373ff7b9'::uuid) OR (other_member_guid = '9aa1da36-18a3-d2fe-5e55-c29cf529e654'::uuid))
  • Filter: (((member_guid = '9aa1da36-18a3-d2fe-5e55-c29cf529e654'::uuid) AND (other_member_guid = '957a8d87-430a-946f-725a-4c9c373ff7b9'::uuid)) OR ((member_guid = '957a8d87-430a-946f-725a-4c9c373ff7b9'::uuid) AND (other_member_guid = '9aa1da36-18a3-d2fe-5e55-c29cf529e654'::uuid)))
  • Heap Blocks: exact=1
8. 0.001 0.006 ↓ 0.0 0 1

BitmapOr (cost=8.58..8.58 rows=2 width=0) (actual time=0.005..0.006 rows=0 loops=1)

9. 0.003 0.003 ↑ 1.0 1 1

Bitmap Index Scan on conversation_other_member_guid_idx (cost=0.00..4.29 rows=1 width=0) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (other_member_guid = '957a8d87-430a-946f-725a-4c9c373ff7b9'::uuid)
10. 0.002 0.002 ↑ 1.0 1 1

Bitmap Index Scan on conversation_other_member_guid_idx (cost=0.00..4.29 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=1)

  • Index Cond: (other_member_guid = '9aa1da36-18a3-d2fe-5e55-c29cf529e654'::uuid)
11. 0.004 0.004 ↓ 0.0 0 2

Index Scan using member_profiles_pk on member_profiles mp (cost=0.28..8.30 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=2)

  • Index Cond: (member_guid = c.other_member_guid)
12. 0.006 0.006 ↓ 0.0 0 2

Index Scan using member_blocked_pk on member_blocked mb (cost=0.15..8.17 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=2)

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