explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CpsY

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 8.108 ↑ 1.0 10 1

Limit (cost=1,363.72..1,374.04 rows=10 width=33) (actual time=8.101..8.108 rows=10 loops=1)

  • Output: ti.uuid
  • Buffers: shared hit=719
2. 0.019 8.106 ↑ 117,216.5 10 1

Nested Loop (cost=1,363.72..1,210,932.22 rows=1,172,165 width=33) (actual time=8.101..8.106 rows=10 loops=1)

  • Output: ti.uuid
  • Buffers: shared hit=719
3. 6.192 7.373 ↑ 223.1 7 1

Sort (cost=1,363.02..1,366.93 rows=1,562 width=45) (actual time=7.373..7.373 rows=7 loops=1)

  • Output: task_set_instances_temp_test.uuid, task_set_instances_temp_test.priority, task_set_instances_temp_test.create_time
  • Sort Key: task_set_instances_temp_test.priority, task_set_instances_temp_test.create_time
  • Sort Method: quicksort Memory: 261kB
  • Buffers: shared hit=342
4. 1.181 1.181 ↓ 1.3 2,103 1

Index Only Scan using i_tsi_all_test on booker.task_set_instances_temp_test (cost=0.55..1,280.17 rows=1,562 width=45) (actual time=0.016..1.181 rows=2,103 loops=1)

  • Output: task_set_instances_temp_test.uuid, task_set_instances_temp_test.priority, task_set_instances_temp_test.create_time
  • Index Cond: ((task_set_instances_temp_test.state_name = ANY ('{READY,RUNNING,DEGRADED}'::text[])) AND (task_set_instances_temp_test.env_partition_id IS NULL))
  • Heap Fetches: 2,103
  • Buffers: shared hit=342
5. 0.714 0.714 ↑ 750.0 1 7

Index Scan using idx_task_instances_1 on booker.task_instances ti (cost=0.70..766.86 rows=750 width=66) (actual time=0.102..0.102 rows=1 loops=7)

  • Output: ti.uuid, ti.task_set_instance_uuid, ti.task_type_name, ti.state_name, ti.max_runtime_seconds, ti.start_time, ti.update_time, ti.version, ti.created_by, ti.creation_date, ti.last_updated_by, ti.last_updated_date, ti.partition_key, ti.is_active, ti.task_worker_id
  • Index Cond: ((ti.task_set_instance_uuid = task_set_instances_temp_test.uuid) AND ((ti.state_name)::text = 'READY'::text) AND ((ti.task_type_name)::text = ANY ('{INV_SIM_BATCH,INV_SIM_BATCH_AGGREG}'::text[])))
  • Buffers: shared hit=377
Planning time : 0.284 ms
Execution time : 8.147 ms