explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y4vY

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

Aggregate (cost=3.45..3.46 rows=1 width=4) (actual time=5.274..5.275 rows=1 loops=1)

  • Buffers: shared read=3
  • I/O Timings: read=5.204
2. 5.269 5.269 ↓ 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=5.269..5.269 rows=0 loops=1)

  • Index Cond: (services.inherit_from_id IS NOT NULL)
  • Filter: (services.active AND (services.project_id IS NOT NULL) AND ((services.type)::text = 'JiraService'::text))
  • Rows Removed by Filter: 0
  • Buffers: shared read=3
  • I/O Timings: read=5.204