explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nfuf

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Append (cost=0.33..7.98 rows=2 width=81) (actual rows= loops=)

2.          

CTE cte

3. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.01 rows=1 width=32) (actual rows= loops=)

4.          

CTE cte2

5. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.01 rows=1 width=32) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.31..3.96 rows=1 width=81) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.20..2.64 rows=1 width=69) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.08..1.31 rows=1 width=48) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

CTE Scan on cte (cost=0.00..0.02 rows=1 width=32) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using conversations_pk on conversations c (cost=0.08..1.29 rows=1 width=48) (actual rows= loops=)

  • Index Cond: ((member_guid = cte.member_guid) AND (other_member_guid = cte.other_member_guid))
11. 0.000 0.000 ↓ 0.0

Index Scan using member_profiles_pk on member_profiles mp (cost=0.11..1.32 rows=1 width=37) (actual rows= loops=)

  • Index Cond: (member_guid = cte.member_guid)
12. 0.000 0.000 ↓ 0.0

Index Scan using member_messaging_restrictions_pk on member_messaging_restrictions mr (cost=0.11..1.32 rows=1 width=28) (actual rows= loops=)

  • Index Cond: (member_guid = cte.member_guid)
13. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.31..3.96 rows=1 width=81) (actual rows= loops=)

  • -> Index Scan using member_messaging_restrictions_pk on member_messaging_restrictions mr_1 (cost=0.11..1.32 rows=1 width=28)" Index Cond: (member_guid = cte2.member_guid)
14. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.20..2.64 rows=1 width=69) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.08..1.31 rows=1 width=48) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

CTE Scan on cte2 (cost=0.00..0.02 rows=1 width=32) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Index Scan using conversations_pk on conversations c_1 (cost=0.08..1.29 rows=1 width=48) (actual rows= loops=)

  • Index Cond: ((member_guid = cte2.member_guid) AND (other_member_guid = cte2.other_member_guid))
18. 0.000 0.000 ↓ 0.0

Index Scan using member_profiles_pk on member_profiles mp_1 (cost=0.11..1.32 rows=1 width=37) (actual rows= loops=)

  • Index Cond: (member_guid = cte2.member_guid)