You want to delete the duplicates of a table which does not have any unique column like ID. Then this ctid is useful to delete duplicate even without the unique column. ctid is a system column on the PostgreSQL database.There are several system columns like this. Check this for more https://www.postgresql.org/docs/9.3/ddl-system-columns.html