explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kWhg

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 7.818 ↑ 1.0 10 1

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

  • Output: ti.uuid
  • Buffers: shared hit=687
2. 0.026 7.813 ↑ 132,825.3 10 1

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

  • Output: ti.uuid
  • Buffers: shared hit=687
3. 2.645 5.429 ↑ 196.7 9 1

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

  • Output: task_set_instances.uuid, task_set_instances.priority, task_set_instances.create_time
  • Sort Key: task_set_instances.priority, task_set_instances.create_time
  • Sort Method: quicksort Memory: 188kB
  • Buffers: shared hit=261
4. 2.784 2.784 ↓ 1.0 1,791 1

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

  • Output: task_set_instances.uuid, task_set_instances.priority, task_set_instances.create_time
  • Index Cond: (((task_set_instances.state_name)::text = ANY ('{READY,RUNNING,DEGRADED}'::text[])) AND (task_set_instances.env_partition_id IS NULL))
  • Buffers: shared hit=255
5. 2.358 2.358 ↑ 750.0 1 9

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

  • 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.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=426
Planning time : 0.319 ms
Execution time : 7.882 ms