explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QLy7

Settings
# exclusive inclusive rows x rows loops node
1. 0.073 11,292.286 ↑ 1.0 1 1

Limit (cost=46.59..46.68 rows=1 width=4) (actual time=11,292.266..11,292.286 rows=1 loops=1)

  • Buffers: shared hit=13190 read=10715 dirtied=45
  • I/O Timings: read=11134.602
2. 0.114 11,292.213 ↑ 14,918.1 501 1

Group (cost=0.86..683,432.61 rows=7,473,966 width=4) (actual time=8,987.922..11,292.213 rows=501 loops=1)

  • Group Key: projects.id
  • Buffers: shared hit=13190 read=10715 dirtied=45
  • I/O Timings: read=11134.602
3. 0.170 11,292.099 ↑ 14,918.1 501 1

Merge Join (cost=0.86..664,747.69 rows=7,473,966 width=4) (actual time=8,987.918..11,292.099 rows=501 loops=1)

  • Filter: ((services.id IS NULL) OR ((NOT services.active) AND (services.properties = '{}'::text)))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=13190 read=10715 dirtied=45
  • I/O Timings: read=11134.602
4. 5.116 5.116 ↑ 22,536.3 502 1

Index Only Scan using projects_pkey on public.projects (cost=0.43..311,452.90 rows=11,313,223 width=4) (actual time=3.320..5.116 rows=502 loops=1)

  • Index Cond: (projects.id >= 154014)
  • Heap Fetches: 0
  • Buffers: shared hit=328 read=4
  • I/O Timings: read=4.690
5. 11,286.813 11,286.813 ↑ 1,670.3 6 1

Index Scan using index_services_on_project_id on public.services (cost=0.43..324,862.45 rows=10,022 width=45) (actual time=914.191..11,286.813 rows=6 loops=1)

  • Filter: ((services.type)::text = 'PrometheusService'::text)
  • Rows Removed by Filter: 64461
  • Buffers: shared hit=12862 read=10711 dirtied=45
  • I/O Timings: read=11129.912