explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Kdnf

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

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

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

Initplan (for Result)

3. 0.002 0.436 ↑ 1.0 1 1

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

  • Buffers: shared hit=3 read=2
  • I/O Timings: read=0.335
4. 0.434 0.434 ↑ 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.434..0.434 rows=1 loops=1)

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