explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KbMc

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 152.215 ↓ 0.0 0 1

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

2. 74.873 152.213 ↓ 0.0 0 1

Index Scan using index_workflow_fibers_for_by_timestamp_batch on workflow_fibers (cost=0.42..5,578.44 rows=468 width=1,086) (actual time=152.213..152.213 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: 15468
3.          

SubPlan (for Index Scan)

4. 77.340 77.340 ↑ 1.0 1 15,468

Index Scan using index_workflow_fibers_on_case_file_id_when_interrupting on workflow_fibers interrupted_fibers (cost=0.29..8.31 rows=1 width=0) (actual time=0.005..0.005 rows=1 loops=15,468)

  • Index Cond: (case_file_id = workflow_fibers.case_file_id)
5. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on workflow_fibers interrupted_fibers_1 (cost=1,343.56..63,947.14 rows=29,576 width=4) (never executed)

  • Recheck Cond: (interruption_status = 2)
6. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on index_workflow_fibers_on_case_file_id_when_interrupting (cost=0.00..1,336.17 rows=29,576 width=0) (never executed)

Planning time : 0.781 ms
Execution time : 152.309 ms