Функции задержки выполнения в PostgreSQL. В случае...

SELECT pg_sleep_for('3 minutes') SELECT pg_sleep_until('tomorrow 05:00'); Время выхода из сна может быть и дольше, в зависимости от загрузки сервера СУБД.

PostgreSQL pg_sleep - Database Tutorials

PostgreSQL: Documentation: 16: 9.9. Date/Time Functions and...

SELECT pg_sleep(1.5); SELECT pg_sleep_for('5 minutes'); SELECT pg_sleep_until('tomorrow 03:00') Make sure that your session does not hold more locks than necessary when calling pg_sleep or its variants.

PostgreSQL Sleep Function pg_sleep... :: If Not True Then False

PostgreSQL Sleep Function pg_sleep – Postgres Delay Execution. pg_sleep makes the current session’s process sleep until seconds seconds have elapsed. Seconds is a value of type double precision, so fractional-second delays can be specified.

Задержка выполнения запроса в PostgreSQL

PostgreSQL pg_sleep() Function

postgresql - Выполнение запросов раз в пять секунд - Stack...

How to Use the pg_sleep() Function in... - CommandPrompt Inc.

How pg_sleep() Works in PostgreSQL

In PostgreSQL, you can use the pg_sleep() function to delay execution for a given number of seconds. SELECT clock_timestamp(), pg_sleep(.5), clock_timestamp(), pg_sleep(.5), clock_timestamp()

PostgreSQL PG_SLEEP() Function

The PG_SLEEP() function allows you to create a delay (sleep) in your queries. The following example uses the PG_SLEEP() function to pause the execution for 3 seconds before returning any result