explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qzNl

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.016 1.103 ↓ 0.0 0 1

Sort (cost=426.56..426.57 rows=1 width=33) (actual time=1.103..1.103 rows=0 loops=1)

  • Sort Key: cluster_data.name
  • Sort Method: quicksort Memory: 25kB
2. 0.001 1.087 ↓ 0.0 0 1

Nested Loop (cost=0.28..426.55 rows=1 width=33) (actual time=1.087..1.087 rows=0 loops=1)

3. 1.086 1.086 ↓ 0.0 0 1

Seq Scan on cluster_data (cost=0.00..399.77 rows=15 width=49) (actual time=1.086..1.086 rows=0 loops=1)

  • Filter: (active AND (company_uuid = '587565b0-3893-4df5-a012-a026059369a5'::uuid))
  • Rows Removed by Filter: 8,193
4. 0.000 0.000 ↓ 0.0 0

Index Scan using index_cluster_definitions_on_uuid on cluster_definitions cd (cost=0.28..1.69 rows=1 width=16) (never executed)

  • Index Cond: (uuid = cluster_data.cluster_definition_uuid)
  • Filter: ((cluster_type_code = 6) AND (company_uuid = '587565b0-3893-4df5-a012-a026059369a5'::uuid))
Planning time : 0.545 ms
Execution time : 1.135 ms