PostgreSQL: which transactions have been in progress for more than 10 seconds?

select * from pg_stat_activity where query_start < now() – ’10 seconds’::interval;