explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1Kw6

Settings
# exclusive inclusive rows x rows loops node
1. 0.066 54.561 ↑ 1.0 1 1

Aggregate (cost=1,807.44..1,807.45 rows=1 width=8) (actual time=54.561..54.561 rows=1 loops=1)

  • Buffers: shared hit=560 read=374 dirtied=9
  • I/O Timings: read=48.234
2. 0.571 54.495 ↓ 0.0 0 1

Hash Join (cost=1,680.23..1,807.43 rows=1 width=4) (actual time=54.495..54.495 rows=0 loops=1)

  • Hash Cond: (project_error_tracking_settings.project_id = projects.id)
  • Buffers: shared hit=554 read=374 dirtied=9
  • I/O Timings: read=48.234
3. 0.732 0.732 ↓ 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.028..0.732 rows=4,550 loops=1)

  • Heap Fetches: 321
  • Buffers: shared hit=250
4. 0.195 53.192 ↑ 5.6 365 1

Hash (cost=1,654.38..1,654.38 rows=2,045 width=8) (actual time=53.191..53.192 rows=365 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 31kB
  • Buffers: shared hit=304 read=374 dirtied=9
  • I/O Timings: read=48.234
5. 52.997 52.997 ↑ 5.6 365 1

Index Only Scan using index_projects_on_creator_id_and_created_at_and_id on public.projects (cost=0.56..1,654.38 rows=2,045 width=8) (actual time=0.216..52.997 rows=365 loops=1)

  • Index Cond: ((projects.creator_id >= 0) AND (projects.creator_id <= 9,999) AND (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))
  • Heap Fetches: 11
  • Buffers: shared hit=304 read=374 dirtied=9
  • I/O Timings: read=48.234