explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i2ml

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

Update on tasks task (cost=8.97..167.87 rows=34 width=162) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on tasks task (cost=8.97..167.87 rows=34 width=162) (actual rows= loops=)

  • Recheck Cond: ((locked_at IS NULL) OR (locked_at < '2020-03-24 11:24:08.077372+00'::timestamp with time zone))
  • Filter: ((deactivated_at IS NULL) AND (strategy = 'track'::text))
3. 0.000 0.000 ↓ 0.0

BitmapOr (cost=8.97..8.97 rows=50 width=0) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on locked_at_idx (cost=0.00..4.66 rows=50 width=0) (actual rows= loops=)

  • Index Cond: (locked_at IS NULL)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on locked_at_idx (cost=0.00..4.29 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (locked_at < '2020-03-24 11:24:08.077372+00'::timestamp with time zone)