explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nIpA

Settings
# exclusive inclusive rows x rows loops node
1. 2,484.947 53,880.672 ↓ 1.6 11,746,953 1

Group (cost=10,415.36..343,461.20 rows=7,536,664 width=4) (actual time=8,085.988..53,880.672 rows=11,746,953 loops=1)

  • Group Key: projects.id
  • Buffers: shared hit=8911094 read=64682 dirtied=4270
  • I/O Timings: read=45301.380
2. 2,079.392 51,395.725 ↓ 1.6 11,746,953 1

Merge Join (cost=10,415.36..324,619.54 rows=7,536,664 width=4) (actual time=8,085.985..51,395.725 rows=11,746,953 loops=1)

  • Filter: ((services.id IS NULL) OR ((NOT services.active) AND (services.properties = '{}'::text)))
  • Rows Removed by Filter: 9663
  • Buffers: shared hit=8911094 read=64682 dirtied=4270
  • I/O Timings: read=45301.380
3. 41,226.773 41,226.773 ↓ 1.0 11,756,616 1

Index Only Scan using projects_pkey on public.projects (cost=0.43..285,508.91 rows=11,408,127 width=4) (actual time=3.647..41,226.773 rows=11,756,616 loops=1)

  • Heap Fetches: 85611
  • Buffers: shared hit=8910960 read=56215 dirtied=4202
  • I/O Timings: read=37351.276
4. 24.100 8,089.560 ↓ 1.0 10,129 1

Sort (cost=10,414.93..10,439.98 rows=10,022 width=45) (actual time=8,082.286..8,089.560 rows=10,129 loops=1)

  • Sort Key: services.project_id
  • Sort Method: quicksort Memory: 1037kB
  • Buffers: shared hit=134 read=8467 dirtied=68
  • I/O Timings: read=7950.104
5. 8,065.460 8,065.460 ↓ 1.0 10,129 1

Index Scan using index_services_on_type on public.services (cost=0.56..9,748.92 rows=10,022 width=45) (actual time=7.573..8,065.460 rows=10,129 loops=1)

  • Index Cond: ((services.type)::text = 'PrometheusService'::text)
  • Buffers: shared hit=134 read=8467 dirtied=68
  • I/O Timings: read=7950.104