explain.depesz.com

A tool for finding a real cause for slow queries.

Result: SqK8

options
# exclusive inclusive rows x rows loops node
1. 0.120 0.617 ↓ 5.0 20 1
→

Sort (cost=22.74..22.75 rows=4 width=121) (actual time=0.606..0.617 rows=20 loops=1)

  • Sort Key: project.title
  • Sort Method: quicksort Memory: 27kB
2. 0.066 0.497 ↓ 5.0 20 1
→

Nested Loop (cost=0.00..22.70 rows=4 width=121) (actual time=0.146..0.497 rows=20 loops=1)

3. 0.046 0.231 ↓ 5.0 20 1
→

Nested Loop (cost=0.00..21.51 rows=4 width=9) (actual time=0.103..0.231 rows=20 loops=1)

4. 0.042 0.042 ↑ 1.0 1 1
→

Index Scan using sfuser_username on sfuser (cost=0.00..8.27 rows=1 width=9) (actual time=0.041..0.042 rows=1 loops=1)

  • Index Cond: ((username)::text = 'testuser25'::text)
5. 0.143 0.143 ↓ 5.0 20 1
→

Index Scan using pjmb_member on projectmembership (cost=0.00..13.19 rows=4 width=18) (actual time=0.049..0.143 rows=20 loops=1)

  • Index Cond: ((projectmembership.member_id)::text = (sfuser.id)::text)
6. 0.200 0.200 ↑ 1.0 1 20
→

Index Scan using project_pk on project (cost=0.00..0.29 rows=1 width=121) (actual time=0.010..0.010 rows=1 loops=20)

  • Index Cond: ((project.id)::text = (projectmembership.project_id)::text)
  • Filter: ((NOT project.is_deleted) AND ((project.path)::text ~~ 'projects.%'::text))