Visibility into progress of Postgres transaction with multiple queries

Question

I have a regular case where I run many Postgres queries within a do/begin/end block

DO $$
BEGIN
<queries>
END $$;

In some cases, the databases and queries run a little bit slow and we need visibility to estimate how long the transaction will take and see any problems along the way.

Does there exist a build in postgres way to see which individual query within the transaction is being executed?

Answer 1

The only thing that comes to my mind is to run something like this before each query:

RAISE NOTICE 'Now executing query number 42';

Such messages are reported to the client immediately.