CODEWITHSUNDEEP
sqlpostgresql
Surya
Surya

Reputation: 2699

How to find the current max_parallel_workers value in Postgresql?

To enable parallel query planning Postgresql has many settings like max_parallel_workers and many more. In Postgresql docs how these values must be tweaked is mentioned, however how can we see the current value of such configurations?

Upvotes: 7

Views: 7883

Answers (1)

Jim Jones
Jim Jones

Reputation: 19623

Using SHOW you can get the current values of many system variables and paths.

SHOW max_parallel_workers;

 max_parallel_workers 
----------------------
 8
(1 Zeile)

maybe also interesting ..

SHOW max_worker_processes;

 max_worker_processes 
----------------------
 8
(1 Zeile)

Curious about other variables? Try SHOW all.

Upvotes: 11

Related Questions