explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UgtK : lol

Settings
# exclusive inclusive rows x rows loops node
1. 0.035 5.314 ↓ 27.0 27 1

HashAggregate (cost=18.84..18.85 rows=1 width=4) (actual time=5.310..5.314 rows=27 loops=1)

2. 0.031 5.279 ↓ 27.0 27 1

Nested Loop (cost=11.36..18.84 rows=1 width=4) (actual time=2.902..5.279 rows=27 loops=1)

3. 0.017 3.653 ↓ 29.0 29 1

Nested Loop (cost=10.94..14.38 rows=1 width=4) (actual time=2.790..3.653 rows=29 loops=1)

  • Join Filter: (sentry_organizationmember.id = u0.id)
4. 0.036 2.761 ↓ 5.8 35 1

HashAggregate (cost=10.51..10.57 rows=6 width=12) (actual time=2.752..2.761 rows=35 loops=1)

5. 0.059 2.725 ↓ 5.8 35 1

Nested Loop (cost=7.74..10.50 rows=6 width=12) (actual time=0.697..2.725 rows=35 loops=1)

6. 0.007 1.581 ↓ 5.8 35 1

Nested Loop (cost=7.32..7.64 rows=6 width=4) (actual time=0.529..1.581 rows=35 loops=1)

7. 0.003 0.355 ↑ 1.0 1 1

HashAggregate (cost=6.89..6.90 rows=1 width=16) (actual time=0.355..0.355 rows=1 loops=1)

8. 0.007 0.352 ↑ 1.0 1 1

Nested Loop (cost=0.84..6.89 rows=1 width=16) (actual time=0.350..0.352 rows=1 loops=1)

9. 0.267 0.267 ↑ 1.0 1 1

Index Only Scan using sentry_projectteam_project_id_4b99b03421a3c6e9_uniq on sentry_projectteam (cost=0.42..2.44 rows=1 width=8) (actual time=0.266..0.267 rows=1 loops=1)

  • Index Cond: (project_id = 1377287)
  • Heap Fetches: 1
10. 0.078 0.078 ↑ 1.0 1 1

Index Only Scan using sentry_team_pkey on sentry_team (cost=0.42..4.44 rows=1 width=8) (actual time=0.077..0.078 rows=1 loops=1)

  • Index Cond: (id = sentry_projectteam.team_id)
  • Heap Fetches: 0
11. 1.219 1.219 ↓ 5.8 35 1

Index Scan using sentry_organizationmember_teams_team_id on sentry_organizationmember_teams u1 (cost=0.42..0.68 rows=6 width=8) (actual time=0.173..1.219 rows=35 loops=1)

  • Index Cond: (team_id = sentry_team.id)
  • Filter: is_active
12. 1.085 1.085 ↑ 1.0 1 35

Index Only Scan using sentry_organizationmember_pkey on sentry_organizationmember u0 (cost=0.42..0.47 rows=1 width=8) (actual time=0.031..0.031 rows=1 loops=35)

  • Index Cond: (id = u1.organizationmember_id)
  • Heap Fetches: 10
13. 0.875 0.875 ↑ 1.0 1 35

Index Scan using sentry_organizationmember_pkey on sentry_organizationmember (cost=0.42..0.62 rows=1 width=12) (actual time=0.025..0.025 rows=1 loops=35)

  • Index Cond: (id = u1.organizationmember_id)
  • Filter: ((organization_id = 171519) AND ((user_id <> ALL ('{297571,377767,307281,296343,302206,293343}'::integer[])) OR (user_id IS NULL)))
  • Rows Removed by Filter: 0
14. 1.595 1.595 ↑ 1.0 1 29

Index Scan using auth_user_pkey on auth_user (cost=0.42..4.44 rows=1 width=8) (actual time=0.055..0.055 rows=1 loops=29)

  • Index Cond: (id = sentry_organizationmember.user_id)
  • Filter: is_active