explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nZYw

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 118.145 ↓ 0.0 0 1

Limit (cost=0.42..60.01 rows=5 width=1,086) (actual time=118.145..118.145 rows=0 loops=1)

2. 71.756 118.145 ↓ 0.0 0 1

Index Scan using index_workflow_fibers_for_by_timestamp_batch on workflow_fibers (cost=0.42..5,566.62 rows=467 width=1,086) (actual time=118.145..118.145 rows=0 loops=1)

  • Index Cond: (((status)::text = ANY ('{waiting_timestamp,waithing_for_retry_at_timestamp}'::text[])) AND (expected_timestamp <= '2020-03-25 14:01:27.294425'::timestamp without time zone))
  • Filter: ((interruption_status <> 1) OR (deferred_due_interruption IS NOT TRUE) OR (NOT (alternatives: SubPlan 1 or hashed SubPlan 2)))
  • Rows Removed by Filter: 15463
3.          

SubPlan (for Index Scan)

4. 46.389 46.389 ↑ 1.0 1 15,463

Index Only Scan using index_workflow_fibers_on_case_file_id_when_interrupting2 on workflow_fibers interrupted_fibers (cost=0.29..8.31 rows=1 width=0) (actual time=0.003..0.003 rows=1 loops=15,463)

  • Index Cond: ((case_file_id = workflow_fibers.case_file_id) AND (interruption_status = 2))
  • Heap Fetches: 4612
5. 0.000 0.000 ↓ 0.0 0

Index Only Scan using index_workflow_fibers_on_case_file_id_when_interrupting2 on workflow_fibers interrupted_fibers_1 (cost=0.29..34,252.38 rows=29,523 width=4) (never executed)

  • Index Cond: (interruption_status = 2)
  • Heap Fetches: 0
Planning time : 1.672 ms
Execution time : 118.236 ms