explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s7xc

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.510 ↑ 1.0 10 1

Limit (cost=1.12..181.43 rows=10 width=33) (actual time=0.036..0.510 rows=10 loops=1)

  • Output: ti.uuid
  • Buffers: shared hit=157
2. 0.025 0.510 ↑ 7,596.3 10 1

Nested Loop (cost=1.12..1,369,652.33 rows=75,963 width=33) (actual time=0.036..0.510 rows=10 loops=1)

  • Output: ti.uuid
  • Buffers: shared hit=157
3. 0.065 0.065 ↑ 118.0 15 1

Index Scan using ix12_tsi on booker.task_set_instances (cost=0.42..1,679.70 rows=1,770 width=33) (actual time=0.012..0.065 rows=15 loops=1)

  • Output: task_set_instances.uuid, task_set_instances.description, task_set_instances.requestor, task_set_instances.state_name, task_set_instances.start_time, task_set_instances.update_time, task_s
  • Index Cond: ((task_set_instances.env_partition_id IS NULL) AND ((task_set_instances.state_name)::text = ANY ('{READY,RUNNING,DEGRADED}'::text[])))
  • Buffers: shared hit=9
4. 0.420 0.420 ↑ 750.0 1 15

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

  • 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_b
  • 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=148
Planning time : 0.372 ms
Execution time : 0.548 ms