explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lQVzU

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 12.641 ↓ 28.6 143 1

Append (cost=33.23..265.70 rows=5 width=492) (actual time=2.604..12.641 rows=143 loops=1)

2. 0.001 0.012 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1 (cost=33.23..33.27 rows=1 width=430) (actual time=0.012..0.012 rows=0 loops=1)

3. 0.001 0.011 ↓ 0.0 0 1

GroupAggregate (cost=33.23..33.26 rows=1 width=534) (actual time=0.011..0.011 rows=0 loops=1)

  • Group Key: gc.id, g.id, "user".id
4. 0.003 0.010 ↓ 0.0 0 1

Sort (cost=33.23..33.24 rows=1 width=489) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: gc.id, "user".id
  • Sort Method: quicksort Memory: 25kB
5. 0.000 0.007 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.12..33.22 rows=1 width=489) (actual time=0.007..0.007 rows=0 loops=1)

  • Join Filter: (gs.goal_id = g.id)
6. 0.000 0.007 ↓ 0.0 0 1

Nested Loop (cost=0.85..24.91 rows=1 width=473) (actual time=0.007..0.007 rows=0 loops=1)

7. 0.000 0.007 ↓ 0.0 0 1

Nested Loop (cost=0.56..16.60 rows=1 width=441) (actual time=0.007..0.007 rows=0 loops=1)

8. 0.007 0.007 ↓ 0.0 0 1

Index Scan using goal_comment_goal_id_fk on goal_comment gc (cost=0.28..8.29 rows=1 width=353) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (goal_id = '3fc829a0-3dba-48f5-9a3b-1f1f5d4fd9f5'::uuid)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using user_pkey on "user" (cost=0.29..8.30 rows=1 width=88) (never executed)

  • Index Cond: (id = gc.user_id)
  • Filter: (status = ANY ('{invited,active}'::user_status[]))
10. 0.000 0.000 ↓ 0.0 0

Index Scan using goal_pkey on goal g (cost=0.29..8.30 rows=1 width=32) (never executed)

  • Index Cond: (id = '3fc829a0-3dba-48f5-9a3b-1f1f5d4fd9f5'::uuid)
11. 0.000 0.000 ↓ 0.0 0

Index Only Scan using goal_share_pkey on goal_share gs (cost=0.28..8.30 rows=1 width=32) (never executed)

  • Index Cond: (goal_id = '3fc829a0-3dba-48f5-9a3b-1f1f5d4fd9f5'::uuid)
  • Heap Fetches: 0
12. 0.000 1.281 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=139.14..139.21 rows=2 width=382) (actual time=1.281..1.281 rows=0 loops=1)

13. 0.001 1.281 ↓ 0.0 0 1

GroupAggregate (cost=139.14..139.19 rows=2 width=398) (actual time=1.281..1.281 rows=0 loops=1)

  • Group Key: gn.id, g_1.user_id
14. 0.001 1.280 ↓ 0.0 0 1

Sort (cost=139.14..139.15 rows=2 width=313) (actual time=1.280..1.280 rows=0 loops=1)

  • Sort Key: gn.id, g_1.user_id
  • Sort Method: quicksort Memory: 25kB
15. 0.002 1.279 ↓ 0.0 0 1

Nested Loop (cost=0.57..139.13 rows=2 width=313) (actual time=1.279..1.279 rows=0 loops=1)

16. 0.003 1.022 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.57..16.61 rows=1 width=48) (actual time=1.021..1.022 rows=1 loops=1)

  • Join Filter: (gs_1.goal_id = g_1.id)
17. 0.525 0.525 ↑ 1.0 1 1

Index Scan using goal_pkey on goal g_1 (cost=0.29..8.30 rows=1 width=32) (actual time=0.524..0.525 rows=1 loops=1)

  • Index Cond: (id = '3fc829a0-3dba-48f5-9a3b-1f1f5d4fd9f5'::uuid)
18. 0.494 0.494 ↓ 0.0 0 1

Index Only Scan using goal_share_pkey on goal_share gs_1 (cost=0.28..8.30 rows=1 width=32) (actual time=0.494..0.494 rows=0 loops=1)

  • Index Cond: (goal_id = '3fc829a0-3dba-48f5-9a3b-1f1f5d4fd9f5'::uuid)
  • Heap Fetches: 0
19. 0.255 0.255 ↓ 0.0 0 1

Seq Scan on goal_note gn (cost=0.00..122.50 rows=2 width=281) (actual time=0.255..0.255 rows=0 loops=1)

  • Filter: (goal_id = '3fc829a0-3dba-48f5-9a3b-1f1f5d4fd9f5'::uuid)
  • Rows Removed by Filter: 2360
20. 0.353 11.328 ↓ 71.5 143 1

Nested Loop (cost=1.15..93.17 rows=2 width=632) (actual time=1.310..11.328 rows=143 loops=1)

21. 0.175 2.824 ↓ 71.5 143 1

Nested Loop Left Join (cost=0.86..47.80 rows=2 width=325) (actual time=1.226..2.824 rows=143 loops=1)

  • Filter: ((ahr.user_id IS NULL) = (user_1.id IS NULL))
  • Rows Removed by Filter: 19
22. 0.042 2.163 ↓ 54.0 162 1

Nested Loop (cost=0.57..46.57 rows=3 width=237) (actual time=1.203..2.163 rows=162 loops=1)

23. 0.004 0.707 ↑ 1.0 1 1

Nested Loop (cost=0.29..46.03 rows=1 width=214) (actual time=0.701..0.707 rows=1 loops=1)

24. 0.156 0.156 ↑ 1.0 1 1

Seq Scan on ad_hoc_request_goal ahgg (cost=0.00..37.73 rows=1 width=32) (actual time=0.151..0.156 rows=1 loops=1)

  • Filter: (goal_id = '3fc829a0-3dba-48f5-9a3b-1f1f5d4fd9f5'::uuid)
  • Rows Removed by Filter: 1817
25. 0.547 0.547 ↑ 1.0 1 1

Index Scan using ad_hoc_request_group_pkey on ad_hoc_request_group ahg (cost=0.29..8.30 rows=1 width=182) (actual time=0.547..0.547 rows=1 loops=1)

  • Index Cond: (id = ahgg.ad_hoc_request_group_id)
26. 1.414 1.414 ↓ 54.0 162 1

Index Scan using ad_hoc_request_group_id_email_uk on ad_hoc_request ahr (cost=0.29..0.51 rows=3 width=71) (actual time=0.499..1.414 rows=162 loops=1)

  • Index Cond: (ad_hoc_request_group_id = ahg.id)
27. 0.486 0.486 ↑ 1.0 1 162

Index Scan using user_pkey on "user" user_1 (cost=0.29..0.40 rows=1 width=88) (actual time=0.003..0.003 rows=1 loops=162)

  • Index Cond: (id = ahr.user_id)
  • Filter: (status = ANY ('{invited,active}'::user_status[]))
  • Rows Removed by Filter: 0
28. 0.429 0.429 ↑ 1.0 1 143

Index Scan using ad_hoc_review_ad_hoc_request_id_key on ad_hoc_review ahrv (cost=0.29..0.54 rows=1 width=414) (actual time=0.003..0.003 rows=1 loops=143)

  • Index Cond: (ad_hoc_request_id = ahr.id)
29.          

SubPlan (for Nested Loop)

30. 0.000 7.722 ↓ 0.0 0 143

HashSetOp Intersect (cost=4.30..22.14 rows=2 width=20) (actual time=0.054..0.054 rows=0 loops=143)

31. 0.000 7.722 ↓ 0.0 0 143

Append (cost=4.30..22.13 rows=4 width=20) (actual time=0.053..0.054 rows=0 loops=143)

32. 0.286 7.293 ↓ 0.0 0 143

Subquery Scan on *SELECT* 1_1 (cost=4.30..11.14 rows=2 width=20) (actual time=0.051..0.051 rows=0 loops=143)

33. 0.000 7.007 ↓ 0.0 0 143

Bitmap Heap Scan on ad_hoc_review_share ahrs (cost=4.30..11.12 rows=2 width=16) (actual time=0.049..0.049 rows=0 loops=143)

  • Recheck Cond: (ad_hoc_review_id = ahrv.id)
  • Heap Blocks: exact=11
34. 7.007 7.007 ↓ 0.0 0 143

Bitmap Index Scan on ad_hoc_review_share_pkey (cost=0.00..4.30 rows=2 width=0) (actual time=0.049..0.049 rows=0 loops=143)

  • Index Cond: (ad_hoc_review_id = ahrv.id)
35. 0.286 0.429 ↓ 0.0 0 143

Subquery Scan on *SELECT* 2_1 (cost=4.30..10.96 rows=2 width=20) (actual time=0.003..0.003 rows=0 loops=143)

36. 0.000 0.143 ↓ 0.0 0 143

Bitmap Heap Scan on goal_share gs_2 (cost=4.30..10.94 rows=2 width=16) (actual time=0.001..0.001 rows=0 loops=143)

  • Recheck Cond: (goal_id = ahgg.goal_id)
37. 0.143 0.143 ↓ 0.0 0 143

Bitmap Index Scan on goal_share_pkey (cost=0.00..4.29 rows=2 width=0) (actual time=0.001..0.001 rows=0 loops=143)

  • Index Cond: (goal_id = ahgg.goal_id)
Planning time : 2.300 ms
Execution time : 13.355 ms