explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6gmW

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 28.346 ↑ 1.0 1 1

Limit (cost=0.44..3,476.27 rows=1 width=130) (actual time=28.345..28.346 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=74,441
2. 28.339 28.339 ↑ 1,643.0 1 1

Index Scan Backward using pk_worker_state_machine_trail on public.worker_state_machine_trail workerstat0_ (cost=0.44..5,710,782.21 rows=1,643 width=130) (actual time=28.339..28.339 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
  • Filter: ((workerstat0_.entity_id = '75834'::bigint) AND ((workerstat0_.entity_type)::text = 'WORKER'::text) AND ((workerstat0_.state_machine_id)::text = 'WORKER_STATE_MACHINE'::text))
  • Rows Removed by Filter: 97,609
  • Buffers: shared hit=74,441
Planning time : 0.162 ms
Execution time : 28.365 ms