explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NlvD

Settings
# exclusive inclusive rows x rows loops node
1. 0.044 99.087 ↑ 1.0 1 1

Aggregate (cost=2,785.35..2,785.36 rows=1 width=8) (actual time=99.087..99.087 rows=1 loops=1)

  • Buffers: shared hit=53,516 read=887 dirtied=397
  • I/O Timings: read=57.822
2. 11.206 99.043 ↓ 1.6 30 1

Hash Join (cost=172.84..2,785.30 rows=19 width=4) (actual time=6.898..99.043 rows=30 loops=1)

  • Hash Cond: (projects.id = project_error_tracking_settings.project_id)
  • Buffers: shared hit=53,516 read=887 dirtied=397
  • I/O Timings: read=57.822
3. 86.054 86.054 ↑ 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=0.297..86.054 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=57.822
4. 0.952 1.783 ↓ 1.0 4,550 1

Hash (cost=115.55..115.55 rows=4,548 width=4) (actual time=1.782..1.783 rows=4,550 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 224kB
  • Buffers: shared hit=250
5. 0.831 0.831 ↓ 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.031..0.831 rows=4,550 loops=1)

  • Heap Fetches: 321
  • Buffers: shared hit=250