explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PLY9

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.246 ↑ 1.0 1 1

Aggregate (cost=12.69..12.70 rows=1 width=8) (actual time=0.246..0.246 rows=1 loops=1)

  • Buffers: shared read=3
  • I/O Timings: read=0.217
2. 0.243 0.243 ↓ 0.0 0 1

Index Scan using index_services_on_type_and_id_and_template on public.services (cost=0.42..12.69 rows=1 width=4) (actual time=0.243..0.243 rows=0 loops=1)

  • Index Cond: (((services.type)::text = 'GithubService'::text) AND (services.id >= 0) AND (services.id <= 9999))
  • Filter: (NOT services."default")
  • Rows Removed by Filter: 0
  • Buffers: shared read=3
  • I/O Timings: read=0.217