explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rsCB

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.100 ↑ 1.0 1 1

Limit (cost=61.88..61.89 rows=1 width=8) (actual time=0.100..0.100 rows=1 loops=1)

2. 0.003 0.100 ↑ 1.0 1 1

Aggregate (cost=61.88..61.89 rows=1 width=8) (actual time=0.100..0.100 rows=1 loops=1)

3. 0.010 0.097 ↑ 1.5 15 1

HashAggregate (cost=61.38..61.60 rows=22 width=16) (actual time=0.095..0.097 rows=15 loops=1)

  • Group Key: workspace_member.account_id
4. 0.003 0.087 ↑ 1.5 15 1

Append (cost=4.40..61.33 rows=22 width=16) (actual time=0.022..0.087 rows=15 loops=1)

5. 0.019 0.032 ↑ 1.1 14 1

Bitmap Heap Scan on workspace_member (cost=4.40..51.41 rows=15 width=16) (actual time=0.022..0.032 rows=14 loops=1)

  • Recheck Cond: (workspace_id = '8271b633-a524-46e8-9620-c2d15c7ce3c6'::uuid)
  • Filter: ((member_role <> 'sysadmin'::text) AND (status = 'active'::text))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=10
6. 0.013 0.013 ↑ 1.0 15 1

Bitmap Index Scan on team_member_team_id_account_id_key (cost=0.00..4.39 rows=15 width=0) (actual time=0.013..0.013 rows=15 loops=1)

  • Index Cond: (workspace_id = '8271b633-a524-46e8-9620-c2d15c7ce3c6'::uuid)
7. 0.052 0.052 ↑ 7.0 1 1

Seq Scan on workspace_member_pending (cost=0.00..9.70 rows=7 width=16) (actual time=0.024..0.052 rows=1 loops=1)

  • Filter: ((NOT claimed) AND (member_role <> 'sysadmin'::text) AND (workspace_id = '8271b633-a524-46e8-9620-c2d15c7ce3c6'::uuid))
  • Rows Removed by Filter: 335
Planning time : 0.178 ms