How to clear a table?

Question

PostgreSQL

I have a table with 5,000,000 records and I ran the TRUNCATE table_name CASCADE command and ... this command has been running for 48 hours now?
Please tell us how to clean the table as quickly as possible and how to organize monitoring.

Answer 1

If truncate is executed for more than a second, then truncate is not executed at all, but is waiting for a lock.
Look in pg_stat_activity where state != 'idle' for long running transactions.
Or immediately with a request for pg_locks, for example, like this: https://github.com/dataegret/pg-utils/blob/master/...
Normal monitoring is a separate, complex and sad issue.