explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WyS9

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 6.599 ↑ 1.0 1 1

Result (cost=0.45..0.46 rows=1 width=4) (actual time=6.599..6.599 rows=1 loops=1)

  • Buffers: shared read=4
  • I/O Timings: read=6.414
2.          

Initplan (for Result)

3. 0.002 6.593 ↑ 1.0 1 1

Limit (cost=0.42..0.45 rows=1 width=4) (actual time=6.593..6.593 rows=1 loops=1)

  • Buffers: shared read=4
  • I/O Timings: read=6.414
4. 6.591 6.591 ↑ 69,476.0 1 1

Index Only Scan using index_services_on_type_id_when_active_not_instance_not_template on public.services (cost=0.42..1,937.44 rows=69,476 width=4) (actual time=6.591..6.591 rows=1 loops=1)

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