explain.depesz.com

PostgreSQL's explain analyze made readable

Result: p2xk

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.014 ↑ 1.0 1 1

Aggregate (cost=3.45..3.46 rows=1 width=8) (actual time=0.014..0.014 rows=1 loops=1)

  • Buffers: shared hit=3
2. 0.010 0.010 ↓ 0.0 0 1

Index Scan using index_services_on_inherit_from_id on public.services (cost=0.42..3.45 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (services.inherit_from_id IS NOT NULL)
  • Filter: (services.active AND (services.id >= 0) AND (services.id <= 99,999) AND ((services.type)::text = 'JiraService'::text))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=3