You may be interested in a patch "Adding pg_dump flag for parallel
export to pipes"[1] which allows using pipes in directory former
parallel dump and restore.
There the offsets are implicitly taken care of by the file system.
[1]
https://www.postgresql.org/message-id/CAH5HC97p4kkpikar%2BswuC0Lx4Y
Hello All
In my PG Version 14 log I have set to log the duration of sql (Example of one
log row below).
2025-04-08 07:31:57 UTC:XXX(55994):XXX:[8949]:LOG: duration: 6555.756 ms
execute S_381: {Actual Parameterized Sql executed}
This Shows the Execution of a JDBC Server Side Prepared stateme
Thanks Tom
Perfect.
Anthony Vitale
This message is only for the use of the persons(s) to whom it is intended. It
may contain privileged and confidential information within the meaning of
applicable law. If you are not the intended recipient, please do not use this
information for any purpose
"Vitale, Anthony, Sony Music" writes:
> In my PG Version 14 log I have set to log the duration of sql (Example of one
> log row below).
> 2025-04-08 07:31:57 UTC:XXX(55994):XXX:[8949]:LOG: duration: 6555.756 ms
> execute S_381: {Actual Parameterized Sql executed}
> This Shows the Execution of