explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FEoU

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

Limit (cost=1,599.62..1,734.64 rows=10 width=33) (actual time=12.540..12.555 rows=10 loops=1)

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

Hash Join (cost=1,599.62..17,936,153.85 rows=1,328,253 width=33) (actual time=12.540..12.554 rows=10 loops=1)

  • Output: ti.uuid
  • Hash Cond: (ti.task_set_instance_uuid = tsi.uuid)
  • Buffers: shared hit=390
3. 6.218 6.218 ↑ 2,465,898.4 12 1

Index Scan using i_taskinst_statename on booker.task_instances ti (cost=0.57..17,810,306.85 rows=29,590,781 width=66) (actual time=0.056..6.218 rows=12 loops=1)

  • 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.state_name)::text = 'READY'::text)
  • Filter: ((ti.task_type_name)::text = ANY ('{INV_SIM_BATCH,INV_SIM_BATCH_AGGREG}'::text[]))
  • Rows Removed by Filter: 1,506
  • Buffers: shared hit=82
4. 0.358 6.310 ↓ 1.0 1,790 1

Hash (cost=1,576.92..1,576.92 rows=1,770 width=33) (actual time=6.309..6.310 rows=1,790 loops=1)

  • Output: tsi.uuid
  • Buckets: 2,048 Batches: 1 Memory Usage: 130kB
  • Buffers: shared hit=305
5. 0.205 5.952 ↓ 1.0 1,790 1

Subquery Scan on tsi (cost=1,554.80..1,576.92 rows=1,770 width=33) (actual time=5.603..5.952 rows=1,790 loops=1)

  • Output: tsi.uuid
  • Buffers: shared hit=305
6. 3.123 5.747 ↓ 1.0 1,790 1

Sort (cost=1,554.80..1,559.22 rows=1,770 width=45) (actual time=5.603..5.747 rows=1,790 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=305
7. 2.624 2.624 ↓ 1.0 1,790 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.011..2.624 rows=1,790 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=299
Planning time : 2.984 ms
Execution time : 12.615 ms