explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9KHo

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 111.082 ↑ 1.0 2 1

Limit (cost=88,563.12..88,563.13 rows=2 width=19) (actual time=111.078..111.082 rows=2 loops=1)

2. 27.068 111.078 ↑ 39,052.5 2 1

Sort (cost=88,563.12..88,758.38 rows=78,105 width=19) (actual time=111.077..111.078 rows=2 loops=1)

  • Sort Key: is_owner DESC, is_admin DESC, is_coach DESC, user_uuid
  • Sort Method: top-N heapsort Memory: 25kB
3. 73.438 84.010 ↑ 1.0 76,467 1

Bitmap Heap Scan on group_members (cost=2,613.01..87,782.07 rows=78,105 width=19) (actual time=17.825..84.010 rows=76,467 loops=1)

  • Recheck Cond: ((group_uuid = 'ef6e3b74-965c-485f-9194-d638ce6bda25'::uuid) AND (deleted_at IS NULL))
  • Heap Blocks: exact=35,921
4. 10.572 10.572 ↑ 1.0 76,469 1

Bitmap Index Scan on group_members_group_uuid_deleted_at (cost=0.00..2,593.48 rows=78,105 width=0) (actual time=10.571..10.572 rows=76,469 loops=1)

  • Index Cond: ((group_uuid = 'ef6e3b74-965c-485f-9194-d638ce6bda25'::uuid) AND (deleted_at IS NULL))