explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T7uD

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 626.656 ↑ 1.0 1 1

Result (cost=513.85..513.86 rows=1 width=4) (actual time=626.655..626.656 rows=1 loops=1)

  • Buffers: shared hit=356 read=839 dirtied=4
  • I/O Timings: read=617.035
2.          

Initplan (for Result)

3. 0.002 626.649 ↑ 1.0 1 1

Limit (cost=0.56..513.85 rows=1 width=4) (actual time=626.648..626.649 rows=1 loops=1)

  • Buffers: shared hit=356 read=839 dirtied=4
  • I/O Timings: read=617.035
4. 626.647 626.647 ↑ 1,460.0 1 1

Index Scan using services_pkey on public.services (cost=0.56..749,409.27 rows=1,460 width=4) (actual time=626.647..626.647 rows=1 loops=1)

  • Index Cond: (services.id IS NOT NULL)
  • Filter: (services.active AND (NOT services.template) AND ((services.type)::text = 'AssemblaService'::text))
  • Rows Removed by Filter: 3544
  • Buffers: shared hit=356 read=839 dirtied=4
  • I/O Timings: read=617.035