explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fQrK

Settings
# exclusive inclusive rows x rows loops node
1. 3.392 7.354 ↓ 1.0 1,835 1

Sort (cost=1,538.01..1,542.38 rows=1,750 width=45) (actual time=7.222..7.354 rows=1,835 loops=1)

  • Output: uuid, priority, create_time
  • Sort Key: task_set_instances.priority, task_set_instances.create_time
  • Sort Method: quicksort Memory: 192kB
  • Buffers: shared hit=373
2. 3.962 3.962 ↓ 1.0 1,835 1

Index Scan using i_tsi_all on booker.task_set_instances (cost=0.55..1,443.74 rows=1,750 width=45) (actual time=0.032..3.962 rows=1,835 loops=1)

  • Output: uuid, priority, 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=373
Planning time : 0.076 ms
Execution time : 7.549 ms