explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UYXj

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

Limit (cost=1,555.50..1,565.79 rows=10 width=33) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,555.50..1,369,549.55 rows=1,328,253 width=33) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=1,554.80..1,559.22 rows=1,770 width=45) (actual rows= loops=)

  • Sort Key: task_set_instances.priority, task_set_instances.create_time
4. 0.000 0.000 ↓ 0.0

Index Scan using i_tsi_all on task_set_instances (cost=0.55..1,459.31 rows=1,770 width=45) (actual rows= loops=)

  • Index Cond: (((state_name)::text = ANY ('{READY,RUNNING,DEGRADED}'::text[])) AND (env_partition_id IS NULL))
5. 0.000 0.000 ↓ 0.0

Index Scan using idx_task_instances_1 on task_instances ti (cost=0.70..765.37 rows=750 width=66) (actual rows= loops=)

  • Index Cond: ((task_set_instance_uuid = task_set_instances.uuid) AND ((state_name)::text = 'READY'::text) AND ((task_type_name)::text = ANY ('{INV_SIM_BATCH,INV_SIM_BATCH_AGGREG}'::text[])))