explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FXiD

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.008 ↓ 0.0 0 1

Update on queue_event qeu (cost=26.12..34.19 rows=1 width=164) (actual time=0.008..0.008 rows=0 loops=1)

2.          

CTE ctv

3. 0.000 0.006 ↓ 0.0 0 1

Limit (cost=25.95..25.97 rows=1 width=36) (actual time=0.006..0.006 rows=0 loops=1)

4. 0.000 0.006 ↓ 0.0 0 1

LockRows (cost=25.95..25.97 rows=1 width=36) (actual time=0.006..0.006 rows=0 loops=1)

5. 0.003 0.006 ↓ 0.0 0 1

Sort (cost=25.95..25.96 rows=1 width=36) (actual time=0.005..0.006 rows=0 loops=1)

  • Sort Key: qe.created_date
  • Sort Method: quicksort Memory: 25kB
6. 0.000 0.003 ↓ 0.0 0 1

Nested Loop Anti Join (cost=4.21..25.94 rows=1 width=36) (actual time=0.003..0.003 rows=0 loops=1)

7. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on queue_event qe (cost=0.00..16.88 rows=1 width=30) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((NOT is_failed) AND (status_code = 1))
8. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on queue_event_depend qed (cost=4.21..14.35 rows=7 width=22) (never executed)

  • Recheck Cond: (event_id = qe.event_id)
9. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on uidx_queue_event_depend (cost=0.00..4.21 rows=7 width=0) (never executed)

  • Index Cond: (event_id = qe.event_id)
10. 0.000 0.007 ↓ 0.0 0 1

Nested Loop (cost=0.15..8.22 rows=1 width=164) (actual time=0.007..0.007 rows=0 loops=1)

11. 0.007 0.007 ↓ 0.0 0 1

CTE Scan on ctv t (cost=0.00..0.02 rows=1 width=56) (actual time=0.007..0.007 rows=0 loops=1)

12. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_queue_event on queue_event qeu (cost=0.15..8.17 rows=1 width=114) (never executed)

  • Index Cond: (event_id = t.event_id)