explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LMeI

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 12.463 ↓ 0.0 0 1

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

  • Buffers: shared hit=5,440
2. 0.001 12.463 ↓ 0.0 0 1

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

  • Buffers: shared hit=5,440
3. 12.462 12.462 ↓ 0.0 0 1

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

  • Filter: (cluster_type = 1)
  • Rows Removed by Filter: 30,078
  • Buffers: shared hit=5,440
4. 0.000 0.000 ↓ 0.0 0

Index Scan using index_clusters_applications_prometheus_on_cluster_id on clusters_applications_prometheus (cost=0.28..3.30 rows=1 width=4) (never executed)

  • Index Cond: (cluster_id = clusters.id)
  • Filter: (status = ANY ('{3,5}'::integer[]))
Planning time : 0.228 ms
Execution time : 12.504 ms