explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GfXx

Settings
# exclusive inclusive rows x rows loops node
1. 234.051 308,381.598 ↑ 1.0 1 1

Aggregate (cost=1,772,455.93..1,772,455.94 rows=1 width=4) (actual time=308,381.598..308,381.598 rows=1 loops=1)

  • Buffers: shared hit=4182507 read=468107 dirtied=18767 written=9
  • I/O Timings: read=293453.407 write=0.596
2. 1,034.809 308,147.547 ↑ 1.6 329,445 1

Nested Loop (cost=0.99..1,771,097.14 rows=543,516 width=4) (actual time=2,013.310..308,147.547 rows=329,445 loops=1)

  • Buffers: shared hit=4182507 read=468107 dirtied=18767 written=9
  • I/O Timings: read=293453.407 write=0.596
3. 103,675.900 103,675.900 ↑ 1.4 486,691 1

Index Scan using index_services_on_project_id_and_type on public.services (cost=0.56..627,714.32 rows=670,765 width=4) (actual time=0.018..103,675.900 rows=486,691 loops=1)

  • Filter: services.active
  • Rows Removed by Filter: 3189835
  • Buffers: shared hit=2666955 read=178259 dirtied=4635 written=8
  • I/O Timings: read=94710.782 write=0.513
4. 203,436.838 203,436.838 ↑ 1.0 1 486,691

Index Scan using index_projects_on_id_service_desk_enabled on public.projects (cost=0.43..1.69 rows=1 width=8) (actual time=0.406..0.418 rows=1 loops=486,691)

  • Index Cond: (projects.id = services.project_id)
  • Buffers: shared hit=1515552 read=289848 dirtied=14132 written=1
  • I/O Timings: read=198742.625 write=0.083