Postgresql query in 10 seconds

Question

Is there a way to create a query that will run for exactly ten seconds ? I don't need real data just a way to run a query for a long time so I can test how the system works in that time.

I would prefer not to create a huge table and make a simple select just for this. Any tricks?

Answer 1

pg_sleep:

SELECT pg_sleep(10);

But that will not generate any load on the system if that's your real goal.