explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vUiR

Settings
# exclusive inclusive rows x rows loops node
1. 2,456.986 11,670.650 ↓ 1.5 11,787,560 1

Group (cost=8,307.30..326,694.79 rows=7,799,479 width=4) (actual time=1,532.088..11,670.650 rows=11,787,560 loops=1)

  • Group Key: projects.id
  • Buffers: shared hit=9686294 read=8278
  • I/O Timings: read=1555.643
2. 2,048.838 9,213.664 ↓ 1.5 11,787,560 1

Merge Left Join (cost=8,307.30..307,196.10 rows=7,799,479 width=4) (actual time=1,532.087..9,213.664 rows=11,787,560 loops=1)

  • Merge Cond: (projects.id = services.project_id)
  • Filter: ((services.id IS NULL) OR ((NOT services.active) AND (services.properties = '{}'::text)))
  • Rows Removed by Filter: 9755
  • Buffers: shared hit=9686294 read=8278
  • I/O Timings: read=1555.643
3. 5,621.636 5,621.636 ↑ 1.0 11,797,315 1

Index Only Scan using projects_pkey on projects (cost=0.43..269,217.75 rows=11,797,531 width=4) (actual time=0.113..5,621.636 rows=11,797,315 loops=1)

  • Heap Fetches: 820951
  • Buffers: shared hit=9684060 read=1770
  • I/O Timings: read=181.234
4. 17.573 1,543.190 ↓ 1.0 10,263 1

Sort (cost=8,306.86..8,332.24 rows=10,152 width=45) (actual time=1,531.968..1,543.190 rows=10,263 loops=1)

  • Sort Key: services.project_id
  • Sort Method: quicksort Memory: 1044kB
  • Buffers: shared hit=2234 read=6508
  • I/O Timings: read=1374.409
5. 1,525.617 1,525.617 ↓ 1.0 10,263 1

Index Scan using index_services_on_type on services (cost=0.56..7,631.27 rows=10,152 width=45) (actual time=1.833..1,525.617 rows=10,263 loops=1)

  • Index Cond: ((type)::text = 'PrometheusService'::text)
  • Buffers: shared hit=2234 read=6508
  • I/O Timings: read=1374.409
Planning time : 6.377 ms
Execution time : 12,304.816 ms