explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eqCG

Settings
# exclusive inclusive rows x rows loops node
1. 2.547 132,807.952 ↑ 1.0 1 1

Aggregate (cost=1,259,452.27..1,259,452.28 rows=1 width=8) (actual time=132,807.951..132,807.952 rows=1 loops=1)

  • Buffers: shared hit=1556886 read=421375
  • I/O Timings: read=126221.449
2. 561.776 132,805.405 ↑ 1.8 1,055 1

Nested Loop (cost=0.86..1,259,447.47 rows=1,917 width=4) (actual time=848.232..132,805.405 rows=1,055 loops=1)

  • Buffers: shared hit=1556886 read=421375
  • I/O Timings: read=126221.449
3. 63,886.688 63,886.688 ↓ 1.0 484,801 1

Index Scan using index_services_on_type_and_id_and_template on public.services (cost=0.42..349,568.68 rows=481,037 width=4) (actual time=8.175..63,886.688 rows=484,801 loops=1)

  • Buffers: shared hit=64133 read=130117
  • I/O Timings: read=62563.596
4. 68,356.941 68,356.941 ↓ 0.0 0 484,801

Index Scan using index_projects_on_id_sd on public.projects (cost=0.43..1.88 rows=1 width=8) (actual time=0.141..0.141 rows=0 loops=484,801)

  • Index Cond: (projects.id = services.project_id)
  • Filter: ((projects.creator_id >= 1) AND (projects.creator_id <= 10000))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1492753 read=291258
  • I/O Timings: read=63657.853