explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EKBE

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.421 ↑ 1.0 1 1

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

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

Initplan (for Result)

3. 0.002 0.417 ↑ 1.0 1 1

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

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

Index Only Scan using index_services_on_type_id_when_active_and_not_template on public.services (cost=0.42..2,538.74 rows=70,130 width=4) (actual time=0.415..0.415 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.293