explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wce2i

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 3.014 ↑ 1.0 10 1

Limit (cost=1,667.36..1,677.65 rows=10 width=33) (actual time=2.808..3.014 rows=10 loops=1)

  • Output: ti.uuid
  • Buffers: shared hit=394
2. 0.027 3.013 ↑ 142,430.8 10 1

Nested Loop (cost=1,667.36..1,466,850.07 rows=1,424,308 width=33) (actual time=2.808..3.013 rows=10 loops=1)

  • Output: ti.uuid
  • Buffers: shared hit=394
3. 0.632 2.734 ↑ 158.2 12 1

Sort (cost=1,666.66..1,671.41 rows=1,898 width=45) (actual time=2.733..2.734 rows=12 loops=1)

  • Output: task_set_instances.uuid, task_set_instances.create_time, task_set_instances.priority
  • Sort Key: task_set_instances.create_time, task_set_instances.priority
  • Sort Method: quicksort Memory: 412kB
  • Buffers: shared hit=242
4. 2.102 2.102 ↓ 1.2 2,243 1

Index Scan using i_tsi_all on booker.task_set_instances (cost=0.55..1,563.31 rows=1,898 width=45) (actual time=0.009..2.102 rows=2,243 loops=1)

  • Output: task_set_instances.uuid, task_set_instances.create_time, task_set_instances.priority
  • 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=242
5. 0.252 0.252 ↑ 750.0 1 12

Index Scan using idx_task_instances_1 on booker.task_instances ti (cost=0.70..764.45 rows=750 width=66) (actual time=0.020..0.021 rows=1 loops=12)

  • 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_
  • 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=152
Planning time : 0.288 ms
Execution time : 3.055 ms