explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ahWs

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 336.095 ↑ 1.0 1 1

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

  • Buffers: shared hit=9,761 read=8,794 dirtied=172
  • I/O Timings: read=296.016
2. 5.726 336.066 ↑ 4.7 30 1

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

  • Buffers: shared hit=9,761 read=8,794 dirtied=172
  • I/O Timings: read=296.016
3. 2.740 2.740 ↓ 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.158..2.740 rows=4,550 loops=1)

  • Heap Fetches: 321
  • Buffers: shared hit=236 read=14
  • I/O Timings: read=0.393
4. 327.600 327.600 ↓ 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.072..0.072 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=9,525 read=8,780 dirtied=172
  • I/O Timings: read=295.623