explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HdAN

Settings
# exclusive inclusive rows x rows loops node
1. 269.909 305.071 ↑ 1.1 370,993 1

Bitmap Heap Scan on public.user_hubs (cost=8,147.65..358,879.34 rows=425,377 width=4) (actual time=41.902..305.071 rows=370,993 loops=1)

  • Output: user_hubs.hub_id
  • Recheck Cond: (user_hubs.hub_id = 39)
  • Filter: (user_hubs.deleted_at IS NULL)
  • Rows Removed by Filter: 1786
  • Heap Blocks: exact=40158
  • Buffers: shared read=41180
2. 35.162 35.162 ↑ 1.2 372,779 1

Bitmap Index Scan on user_hubs_hub_id_user_id_idx (cost=0.00..8,041.31 rows=435,317 width=0) (actual time=35.162..35.162 rows=372,779 loops=1)

  • Index Cond: (user_hubs.hub_id = 39)
  • Buffers: shared read=1022
Planning time : 2.251 ms
Execution time : 330.474 ms