explain.depesz.com

PostgreSQL's explain analyze made readable

Result: e93d

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 14.896 ↑ 1.0 1 1

Result (cost=1.24..1.25 rows=1 width=4) (actual time=14.896..14.896 rows=1 loops=1)

  • Buffers: shared hit=6,351
2.          

Initplan (for Result)

3. 0.003 14.890 ↑ 1.0 1 1

Limit (cost=0.42..1.24 rows=1 width=4) (actual time=14.889..14.890 rows=1 loops=1)

  • Buffers: shared hit=6,351
4. 14.887 14.887 ↑ 70,130.0 1 1

Index Scan using services_pkey on public.services (cost=0.42..57,229.58 rows=70,130 width=4) (actual time=14.887..14.887 rows=1 loops=1)

  • Index Cond: (services.id IS NOT NULL)
  • Filter: (services.active AND (services.project_id IS NOT NULL) AND ((services.type)::text = 'JiraService'::text))
  • Rows Removed by Filter: 30,209
  • Buffers: shared hit=6,351