explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g8ce

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.043 ↑ 1.0 1 1

Aggregate (cost=221.16..221.17 rows=1 width=8) (actual time=0.043..0.043 rows=1 loops=1)

  • Buffers: shared hit=4
2. 0.036 0.036 ↑ 993.8 4 1

Index Only Scan using index_services_on_type_id_when_active_and_project_id_not_null on public.services (cost=0.42..211.23 rows=3,975 width=4) (actual time=0.035..0.036 rows=4 loops=1)

  • Index Cond: ((services.type = 'JiraService'::text) AND (services.id >= 0) AND (services.id <= 99,999))
  • Heap Fetches: 0
  • Buffers: shared hit=4