slow query script code example

Example: slow query script

SELECT  pid,  now() - pg_stat_activity.query_start AS duration,  query,  stateFROM pg_stat_activityWHERE (now() - pg_stat_activity.query_start) > interval '5 minutes';