explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VIl9

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.038 8,983.249 ↓ 0.0 0 1

Sort (cost=50,984.70..50,984.70 rows=1 width=248) (actual time=8,983.249..8,983.249 rows=0 loops=1)

  • Sort Key: machine_created_at
  • Sort Method: quicksort Memory: 25kB
2. 8,983.211 8,983.211 ↓ 0.0 0 1

Index Scan using ix_machine_transitions_machine_workflow_id on machine_transitions (cost=0.43..50,984.69 rows=1 width=248) (actual time=8,983.211..8,983.211 rows=0 loops=1)

  • Index Cond: ((machine_workflow_id)::text = 'number-delete-v1'::text)
  • Filter: ((((end_state)::text <> ''::text) IS NOT TRUE) AND (run_at <= '2019-11-27 22:24:03.405063'::timestamp without time zone))
  • Rows Removed by Filter: 782868
Planning time : 0.159 ms
Execution time : 8,983.286 ms