explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KdOm : Add index company_uuid #qzNl

Settings

Optimization path:

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

Sort (cost=15.18..15.19 rows=1 width=48) (actual rows= loops=)

  • Sort Key: cluster_data.name
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..15.17 rows=1 width=48) (actual rows= loops=)

  • Join Filter: (cluster_data.cluster_definition_uuid = cd.uuid)
3. 0.000 0.000 ↓ 0.0

Seq Scan on cluster_data (cost=0.00..1.26 rows=1 width=64) (actual rows= loops=)

  • Filter: (active AND (company_uuid = '587565b0-3893-4df5-a012-a026059369a5'::uuid))
4. 0.000 0.000 ↓ 0.0

Seq Scan on cluster_definitions cd (cost=0.00..13.90 rows=1 width=16) (actual rows= loops=)

  • Filter: ((cluster_type_code = 6) AND (company_uuid = '587565b0-3893-4df5-a012-a026059369a5'::uuid))