explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QidB

Settings
# exclusive inclusive rows x rows loops node
1. 28,506.289 28,506.289 ↓ 1.0 785,805 1

Index Scan using ix_machine_transitions_machine_workflow_id_machine_mach_22c4 on machine_transitions (cost=0.43..63,915.13 rows=762,332 width=53) (actual time=0.017..28,506.289 rows=785,805 loops=1)

  • Index Cond: ((machine_workflow_id)::text = 'number-delete-v1'::text)
Planning time : 0.100 ms
Execution time : 29,381.552 ms