explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QKK5

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

Insert on queue_event (cost=50.28..50.34 rows=3 width=97) (actual time=0.004..0.004 rows=0 loops=1)

2.          

CTE ctv_del

3. 0.001 0.003 ↓ 0.0 0 1

Delete on queue_event qed (cost=16.89..50.28 rows=3 width=12) (actual time=0.003..0.003 rows=0 loops=1)

4. 0.000 0.002 ↓ 0.0 0 1

Hash Join (cost=16.89..50.28 rows=3 width=12) (actual time=0.002..0.002 rows=0 loops=1)

  • Hash Cond: (tu.event_id = qed.event_id)
5. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on tmp_queue_event tu (cost=0.00..28.50 rows=1,850 width=22) (actual time=0.002..0.002 rows=0 loops=1)

6. 0.000 0.000 ↓ 0.0 0

Hash (cost=16.88..16.88 rows=1 width=22) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Seq Scan on queue_event qed (cost=0.00..16.88 rows=1 width=22) (never executed)

  • Filter: (try_count >= '5'::smallint)
8. 0.003 0.003 ↓ 0.0 0 1

CTE Scan on ctv_del t (cost=0.00..0.06 rows=3 width=97) (actual time=0.003..0.003 rows=0 loops=1)