explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q69b

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.473 ↑ 1.0 1 1

Result (cost=0.46..0.47 rows=1 width=4) (actual time=0.473..0.473 rows=1 loops=1)

  • Buffers: shared hit=1 read=3
  • I/O Timings: read=0.291
2.          

Initplan (for Result)

3. 0.002 0.468 ↑ 1.0 1 1

Limit (cost=0.42..0.46 rows=1 width=4) (actual time=0.468..0.468 rows=1 loops=1)

  • Buffers: shared hit=1 read=3
  • I/O Timings: read=0.291
4. 0.466 0.466 ↑ 70,130.0 1 1

Index Only Scan using index_services_on_type_id_when_active_and_project_id_not_null on public.services (cost=0.42..2,538.74 rows=70,130 width=4) (actual time=0.466..0.466 rows=1 loops=1)

  • Index Cond: ((services.type = 'JiraService'::text) AND (services.id IS NOT NULL))
  • Heap Fetches: 0
  • Buffers: shared hit=1 read=3
  • I/O Timings: read=0.291