archwhite
3/17/2016 - 2:49 AM

SQL convenient scripts

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";