SQL convenient scripts
-- truncate table with foreign keys (MSSQL notation)
DELETE FROM TABLENAME;
DBCC CHECKIDENT ('DATABASENAME.dbo.TABLENAME',RESEED, 0);
-- print out list of sql commands in processing
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-- common delay (e.g. 10sec)
select * from dbo."Tasks", pg_sleep(10);
-- delay for every row
select pg_sleep(1), * from dbo."Tasks";