explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RsIm

Settings
# exclusive inclusive rows x rows loops node
1. 0.038 567.994 ↓ 0.0 0 1

Limit (cost=0.57..2,584.72 rows=1 width=4) (actual time=567.994..567.994 rows=0 loops=1)

  • Buffers: shared hit=4,693 read=548 dirtied=2
  • I/O Timings: read=545.620
2. 0.003 567.956 ↓ 0.0 0 1

Nested Loop (cost=0.57..2,584.72 rows=1 width=4) (actual time=567.956..567.956 rows=0 loops=1)

  • Buffers: shared hit=4,693 read=548 dirtied=2
  • I/O Timings: read=545.620
3. 567.953 567.953 ↓ 0.0 0 1

Index Scan using clusters_pkey on public.clusters (cost=0.29..2,580.41 rows=1 width=4) (actual time=567.953..567.953 rows=0 loops=1)

  • Filter: (clusters.cluster_type = 1)
  • Rows Removed by Filter: 29,915
  • Buffers: shared hit=4,693 read=548 dirtied=2
  • I/O Timings: read=545.620
4. 0.000 0.000 ↓ 0.0 0 0

Index Scan using index_clusters_applications_prometheus_on_cluster_id on public.clusters_applications_prometheus (cost=0.28..4.30 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=0)

  • Index Cond: (clusters_applications_prometheus.cluster_id = clusters.id)
  • Filter: (clusters_applications_prometheus.status = ANY ('{3,5}'::integer[]))
  • Rows Removed by Filter: 0