explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yxlj

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 47.913 ↑ 1.0 1 1

Aggregate (cost=15,510.61..15,510.62 rows=1 width=4) (actual time=47.913..47.913 rows=1 loops=1)

  • Buffers: shared hit=18,476
2. 0.767 47.895 ↑ 4.7 30 1

Nested Loop (cost=0.72..15,510.26 rows=141 width=4) (actual time=47.622..47.895 rows=30 loops=1)

  • Buffers: shared hit=18,476
3. 1.628 1.628 ↓ 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.035..1.628 rows=4,550 loops=1)

  • Heap Fetches: 321
  • Buffers: shared hit=250
4. 45.500 45.500 ↓ 0.0 0 4,550

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

  • Index Cond: (projects.id = project_error_tracking_settings.project_id)
  • Filter: ((projects.created_at >= '2020-09-16 06:21:16.595342+00'::timestamp with time zone) AND (projects.created_at <= '2020-10-14 06:21:16.595471+00'::timestamp with time zone))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=18,226