explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n4Sb

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.137 ↑ 1.0 1 1

Limit (cost=15.60..15.61 rows=1 width=8) (actual time=0.137..0.137 rows=1 loops=1)

  • Buffers: shared hit=14
2. 0.008 0.136 ↑ 1.0 1 1

Aggregate (cost=15.60..15.61 rows=1 width=8) (actual time=0.136..0.136 rows=1 loops=1)

  • Buffers: shared hit=14
3. 0.004 0.128 ↑ 2.0 1 1

Nested Loop Anti Join (cost=1.00..15.59 rows=2 width=4) (actual time=0.123..0.128 rows=1 loops=1)

  • Buffers: shared hit=14
4. 0.091 0.091 ↑ 2.0 1 1

Index Only Scan using index_projects_on_id_and_archived_and_pending_delete on public.projects (cost=0.43..5.40 rows=2 width=4) (actual time=0.086..0.091 rows=1 loops=1)

  • Index Cond: (projects.id = ANY ('{3,4}'::integer[]))
  • Heap Fetches: 0
  • Buffers: shared hit=10
5. 0.033 0.033 ↓ 0.0 0 1

Index Only Scan using index_services_on_project_id_and_type on public.services (cost=0.56..3.58 rows=1 width=4) (actual time=0.033..0.033 rows=0 loops=1)

  • Index Cond: ((services.project_id = projects.id) AND (services.type = 'JiraService'::text))
  • Heap Fetches: 0
  • Buffers: shared hit=4