explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mdJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.089 ↑ 1.0 1 1

Limit (cost=3,381.69..3,381.69 rows=1 width=130) (actual time=0.087..0.089 rows=1 loops=1)

  • Output: id, type, uuid, created_date, entity_id, entity_type, current_state, previous_state, previous_state_duration_seconds, state_machine_id, event_id
  • Buffers: shared hit=8
2. 0.028 0.086 ↑ 1,609.0 1 1

Sort (cost=3,381.69..3,385.71 rows=1,609 width=130) (actual time=0.085..0.086 rows=1 loops=1)

  • Output: id, type, uuid, created_date, entity_id, entity_type, current_state, previous_state, previous_state_duration_seconds, state_machine_id, event_id
  • Sort Key: workerstat0_.id DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=8
3. 0.058 0.058 ↑ 1,609.0 1 1

Index Scan using idx_worker_state_machine_trail_id_type_smid on public.worker_state_machine_trail workerstat0_ (cost=0.56..3,373.64 rows=1,609 width=130) (actual time=0.058..0.058 rows=1 loops=1)

  • Output: id, type, uuid, created_date, entity_id, entity_type, current_state, previous_state, previous_state_duration_seconds, state_machine_id, event_id
  • Index Cond: ((workerstat0_.entity_id = '75834'::bigint) AND ((workerstat0_.entity_type)::text = 'WORKER'::text) AND ((workerstat0_.state_machine_id)::text = 'WORKER_STATE_MACHINE'::text))
  • Buffers: shared hit=5
Planning time : 1.052 ms
Execution time : 0.132 ms