explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YvRx

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 398.360 ↑ 1.0 1 1

Aggregate (cost=71,325.23..71,325.24 rows=1 width=0) (actual time=398.359..398.360 rows=1 loops=1)

2. 328.587 398.355 ↓ 0.0 0 1

Bitmap Heap Scan on workflow_fibers (cost=859.71..71,267.63 rows=23,040 width=0) (actual time=398.355..398.355 rows=0 loops=1)

  • Recheck Cond: ((step_id = 1,474) AND ((status)::text = 'waiting_children'::text) AND (created_at < '2020-09-08 16:55:28.834378'::timestamp without time zone))
  • Filter: ((NOT (unsynchronized_step_ids @> '{12324}'::integer[])) AND (NOT (synchronized_step_ids @> '{12324}'::integer[])))
  • Rows Removed by Filter: 141,853
  • Heap Blocks: exact=94,497
3. 69.768 69.768 ↓ 12.5 288,695 1

Bitmap Index Scan on tmp_index_workflow_fibers_for_sync_op (cost=0.00..853.95 rows=23,162 width=0) (actual time=69.768..69.768 rows=288,695 loops=1)

  • Index Cond: ((step_id = 1,474) AND ((status)::text = 'waiting_children'::text) AND (created_at < '2020-09-08 16:55:28.834378'::timestamp without time zone))
Planning time : 1.498 ms
Execution time : 398.898 ms