Check out our free resources, like our Effective Indexing in Postgres eBook and sign up to our newsletter. Notice: We've updated our Privacy Policy, effective April 28, 2023.

EXPLAIN - Modify Table (Delete, Insert, Update)


Apply rows produced by a subplan to a result table by inserting, updating, or deleting rows corresponding to the input.

Important Fields:

  • Conflict Arbiter Indexes
  • Conflict Filter
  • Conflicting Tuples
  • Conflict Resolution
  • Operation
  • Rows Removed by Conflict Filter
  • Tuples Inserted

Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →