explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lin2

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.449 ↑ 6.0 25 1

Append (cost=1.88..511.16 rows=150 width=248) (actual time=0.054..0.449 rows=25 loops=1)

2. 0.000 0.443 ↑ 5.7 25 1

Nested Loop Left Join (cost=1.88..468.83 rows=143 width=248) (actual time=0.053..0.443 rows=25 loops=1)

3. 0.024 0.244 ↑ 5.7 25 1

Nested Loop (cost=1.77..279.35 rows=143 width=88) (actual time=0.041..0.244 rows=25 loops=1)

4. 0.044 0.070 ↑ 5.7 25 1

Bitmap Heap Scan on conversations sc (cost=1.66..89.88 rows=143 width=40) (actual time=0.032..0.070 rows=25 loops=1)

  • Recheck Cond: ((member_guid = '3d176a07-6cf1-dbf5-b3f5-60166d429290'::uuid) OR (other_member_guid = '3d176a07-6cf1-dbf5-b3f5-60166d429290'::uuid))
  • Heap Blocks: exact=25
5. 0.000 0.026 ↓ 0.0 0 1

BitmapOr (cost=1.66..1.66 rows=143 width=0) (actual time=0.026..0.026 rows=0 loops=1)

6. 0.015 0.015 ↑ 3.4 21 1

Bitmap Index Scan on conversations_member_guid_idx (cost=0.00..0.82 rows=71 width=0) (actual time=0.015..0.015 rows=21 loops=1)

  • Index Cond: (member_guid = '3d176a07-6cf1-dbf5-b3f5-60166d429290'::uuid)
7. 0.011 0.011 ↑ 18.0 4 1

Bitmap Index Scan on conversations_other_member_guid_idx (cost=0.00..0.82 rows=72 width=0) (actual time=0.011..0.011 rows=4 loops=1)

  • Index Cond: (other_member_guid = '3d176a07-6cf1-dbf5-b3f5-60166d429290'::uuid)
8. 0.150 0.150 ↑ 1.0 1 25

Index Scan using conversations_pk on conversations pc (cost=0.11..1.32 rows=1 width=56) (actual time=0.006..0.006 rows=1 loops=25)

  • Index Cond: (conversation_id = sc.conversation_id)
9. 0.200 0.200 ↑ 1.0 1 25

Index Scan using member_profiles_pk on member_profiles mp (cost=0.11..1.32 rows=1 width=152) (actual time=0.008..0.008 rows=1 loops=25)

  • Index Cond: (member_guid = CASE WHEN ('3d176a07-6cf1-dbf5-b3f5-60166d429290'::uuid IS DISTINCT FROM sc.member_guid) THEN sc.member_guid ELSE sc.other_member_guid END)
10. 0.000 0.003 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.50..40.08 rows=7 width=248) (actual time=0.003..0.003 rows=0 loops=1)

11. 0.000 0.003 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.39..30.46 rows=7 width=208) (actual time=0.003..0.003 rows=0 loops=1)

12. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on mutual sm (cost=1.28..21.18 rows=7 width=56) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((member_guid = '09fb7157-8bfd-0959-dd7c-fe34a43f902a'::uuid) OR (other_member_guid = '09fb7157-8bfd-0959-dd7c-fe34a43f902a'::uuid))
  • Filter: ((member_guid = '09fb7157-8bfd-0959-dd7c-fe34a43f902a'::uuid) OR ((other_member_guid = '09fb7157-8bfd-0959-dd7c-fe34a43f902a'::uuid) AND (NOT (SubPlan 1))))
13. 0.000 0.002 ↓ 0.0 0 1

BitmapOr (cost=1.28..1.28 rows=10 width=0) (actual time=0.002..0.002 rows=0 loops=1)

14. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on mutual_member_guid_idx (cost=0.00..0.64 rows=5 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (member_guid = '09fb7157-8bfd-0959-dd7c-fe34a43f902a'::uuid)
15. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on mutual_other_member_guid_idx (cost=0.00..0.64 rows=5 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (other_member_guid = '09fb7157-8bfd-0959-dd7c-fe34a43f902a'::uuid)
16.          

SubPlan (for Bitmap Heap Scan)

17. 0.000 0.000 ↓ 0.0 0

Index Only Scan using conversations_member_other_member_uc on conversations sc_1 (cost=0.11..1.33 rows=1 width=0) (never executed)

  • Index Cond: ((member_guid = sm.member_guid) AND (other_member_guid = sm.other_member_guid))
  • Heap Fetches: 0
18. 0.000 0.000 ↓ 0.0 0

Index Scan using member_profiles_pk on member_profiles mp_1 (cost=0.11..1.32 rows=1 width=168) (never executed)

  • Index Cond: (member_guid = CASE WHEN ('09fb7157-8bfd-0959-dd7c-fe34a43f902a'::uuid IS DISTINCT FROM sm.member_guid) THEN sm.member_guid ELSE sm.other_member_guid END)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using member_profiles_pk on member_profiles mp2 (cost=0.11..1.32 rows=1 width=32) (never executed)

  • Index Cond: (member_guid = CASE WHEN ('09fb7157-8bfd-0959-dd7c-fe34a43f902a'::uuid IS DISTINCT FROM sm.member_guid) THEN sm.other_member_guid ELSE sm.member_guid END)
Planning time : 0.686 ms