explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mBHf

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 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)

  • -> 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);
  • DELETE
  • WHERE 1=1
  • RETURNING qed.event_Id
  • INSERT INTO tvs_history.queue_event
  • (event_Id, object_id, object_key, event_type_Id, client_partition_Id,
  • created_date, is_failed, try_count, try_date, status_code, move_to_history_date)
  • SELECT t.event_Id
  • FROM ctv_del AS t
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)

  • FROM tvs_sync.queue_event AS qed
  • USING tmp_queue_event AS tu
  • AND qed.event_id = tu.event_Id
  • AND qed.try_count >= m_max_try_count
  • ,t.object_id
  • ,t.object_key
  • ,t.event_type_Id
  • ,t.client_partition_Id
  • ,t.created_date
  • ,t.is_failed
  • ,t.try_count
  • ,t.try_date
  • ,t.status_code
  • ,m_now
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)
  • ,qed.object_id
  • ,qed.object_key
  • ,qed.event_type_Id
  • ,qed.client_partition_Id
  • ,qed.created_date
  • ,qed.is_failed
  • ,qed.try_count
  • ,qed.try_date
  • ,qed.status_code
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)