explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MLQ5

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.967 ↑ 1.0 1 1

Limit (cost=0.56..2.66 rows=1 width=130) (actual time=0.966..0.967 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=2 read=3
2. 0.965 0.965 ↑ 1,643.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,448.27 rows=1,643 width=130) (actual time=0.965..0.965 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=2 read=3
Planning time : 0.149 ms
Execution time : 0.986 ms