explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5RgM

Settings
# exclusive inclusive rows x rows loops node
1. 0.086 1,034.409 ↑ 1.0 1 1

Aggregate (cost=3,117.70..3,117.71 rows=1 width=8) (actual time=1,034.409..1,034.409 rows=1 loops=1)

  • Buffers: shared hit=58,021 read=887 dirtied=397
  • I/O Timings: read=960.023
2. 21.664 1,034.323 ↓ 1.6 30 1

Hash Join (cost=505.19..3,117.65 rows=19 width=4) (actual time=42.497..1,034.323 rows=30 loops=1)

  • Hash Cond: (projects.id = project_error_tracking_settings.project_id)
  • Buffers: shared hit=58,021 read=887 dirtied=397
  • I/O Timings: read=960.023
3. 1,007.735 1,007.735 ↑ 1.0 65,362 1

Index Only Scan using index_projects_on_creator_id_and_id on public.projects (cost=0.43..2,440.07 rows=65,838 width=8) (actual time=2.881..1,007.735 rows=65,362 loops=1)

  • Index Cond: ((projects.creator_id >= 0) AND (projects.creator_id <= 9,999))
  • Heap Fetches: 797
  • Buffers: shared hit=53,266 read=887 dirtied=397
  • I/O Timings: read=960.023
4. 1.330 4.924 ↓ 1.0 4,550 1

Hash (cost=448.76..448.76 rows=4,479 width=4) (actual time=4.923..4.924 rows=4,550 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 224kB
  • Buffers: shared hit=4,755
5. 3.594 3.594 ↓ 1.0 4,550 1

Index Scan using project_error_tracking_settings_pkey on public.project_error_tracking_settings (cost=0.28..448.76 rows=4,479 width=4) (actual time=0.019..3.594 rows=4,550 loops=1)

  • Filter: project_error_tracking_settings.enabled
  • Rows Removed by Filter: 498
  • Buffers: shared hit=4,755