explain.depesz.com

PostgreSQL's explain analyze made readable

Result: reTF

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 0.081 ↑ 1.0 1 1

Aggregate (cost=4.73..4.74 rows=1 width=8) (actual time=0.081..0.081 rows=1 loops=1)

  • Buffers: shared hit=5
2. 0.061 0.061 ↓ 1.1 12 1

Index Only Scan using index_services_on_type_and_id_and_template on public.services (cost=0.42..4.70 rows=11 width=4) (actual time=0.057..0.061 rows=12 loops=1)

  • Index Cond: ((services.type = 'AssemblaService'::text) AND (services.id >= 0) AND (services.id <= 99999) AND (services.template = false))
  • Heap Fetches: 0
  • Filter: (NOT services.template)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=5