explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wLlP

Settings
# exclusive inclusive rows x rows loops node
1. 0.947 27.463 ↑ 1.0 1 1

Aggregate (cost=15,498.89..15,498.90 rows=1 width=4) (actual time=27.462..27.463 rows=1 loops=1)

  • Buffers: shared hit=18,454
2. 2.638 26.516 ↓ 1.0 4,550 1

Nested Loop (cost=0.72..15,487.52 rows=4,548 width=4) (actual time=0.083..26.516 rows=4,550 loops=1)

  • Buffers: shared hit=18,454
3. 1.128 1.128 ↓ 1.0 4,550 1

Index Only Scan using idx_project_error_tracking_settings_on on public.project_error_tracking_settings (cost=0.28..115.55 rows=4,548 width=4) (actual time=0.033..1.128 rows=4,550 loops=1)

  • Heap Fetches: 321
  • Buffers: shared hit=250
4. 22.750 22.750 ↑ 1.0 1 4,550

Index Scan using projects_pkey on public.projects (cost=0.43..3.38 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=4,550)

  • Index Cond: (projects.id = project_error_tracking_settings.project_id)
  • Buffers: shared hit=18,204