explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4UHv

Settings
# exclusive inclusive rows x rows loops node
1. 0.054 0.081 ↑ 1.0 1 1

Aggregate (cost=4.67..4.68 rows=1 width=8) (actual time=0.080..0.081 rows=1 loops=1)

  • Buffers: shared hit=10
2. 0.027 0.027 ↓ 0.0 0 1

Index Only Scan using index_group_import_states_on_user_id on public.group_import_states (cost=0.12..4.67 rows=3 width=8) (actual time=0.027..0.027 rows=0 loops=1)

  • Index Cond: ((group_import_states.user_id >= 1) AND (group_import_states.user_id <= 10,000))
  • Heap Fetches: 0
  • Buffers: shared hit=4