explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XvD2

Settings
# exclusive inclusive rows x rows loops node
1. 1,099.620 1,504.420 ↑ 2.1 35,536 1

Bitmap Heap Scan on public.user_hubs (cost=8,177.66..359,871.01 rows=75,589 width=4) (actual time=413.664..1,504.420 rows=35,536 loops=1)

  • Output: user_hubs.user_id
  • Recheck Cond: ((user_hubs.hub_id = 39) AND (user_hubs.deleted_at IS NULL))
  • Rows Removed by Index Recheck: 57656
  • Filter: (user_hubs.user_type ~~ 'student'::text)
  • Rows Removed by Filter: 335457
  • Heap Blocks: exact=36391 lossy=33305
  • Buffers: shared read=71844
2. 404.800 404.800 ↓ 1.7 734,938 1

Bitmap Index Scan on user_hubs_user_id_hub_id_unique (cost=0.00..8,158.76 rows=425,377 width=0) (actual time=404.800..404.800 rows=734,938 loops=1)

  • Index Cond: (user_hubs.hub_id = 39)
  • Buffers: shared read=2148
Planning time : 0.246 ms
Execution time : 1,506.845 ms