explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pr8Q

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.142 ↑ 1.0 1 1

Aggregate (cost=3,908.07..3,908.08 rows=1 width=8) (actual time=0.141..0.142 rows=1 loops=1)

  • Buffers: shared hit=7
2. 0.134 0.134 ↑ 642.5 4 1

Index Scan using index_services_on_type_and_id_and_template_when_active on public.services (cost=0.42..3,901.65 rows=2,570 width=4) (actual time=0.076..0.134 rows=4 loops=1)

  • Index Cond: (((services.type)::text = 'JiraService'::text) AND (services.id >= 0) AND (services.id <= 99,999) AND (services.template = false))
  • Filter: ((NOT services.template) AND (NOT services.instance))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=7