explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mMBM

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=8,911,094 read=64,682 dirtied=4,270
  • I/O Timings: read=45,301.380
  • - planning: 2.892 ms
  • - execution: 54.493 s
  • - hits: 8,911,094 (~68.00 GiB) from the buffer pool
  • - reads: 64,682 (~505.30 MiB) from the OS file cache, including disk I/O
  • - dirtied: 4,270 (~33.40 MiB)
  • - writes: 0
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: 9,663
  • Buffers: shared hit=8,911,094 read=64,682 dirtied=4,270
  • I/O Timings: read=45,301.380
  • - I/O read: 45.301 s
  • - I/O write: 0.000 ms
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: 85,611
  • Buffers: shared hit=8,910,960 read=56,215 dirtied=4,202
  • I/O Timings: read=37,351.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: 1,037kB
  • Buffers: shared hit=134 read=8,467 dirtied=68
  • I/O Timings: read=7,950.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=8,467 dirtied=68
  • I/O Timings: read=7,950.104