You can check the action state by using the existing statistics collector. Monitoring the statistics enables you to check the action state of parallel processing through, for example, changes in the system load.
The following table describes the column added to the statistics views:
Column | Data type | Description |
|---|---|---|
parallel_query | bigint | Number of parallel query initialized in the table. |
The parallel query column has also been added to the following views:
pg_stat_sys_tables
pg_stat_user_tables
pg_stat_xact_all_tables
pg_stat_xact_sys_tables
pg_stat_xact_user_tables
See
Refer to "The Statistics Collector" in "Server Administration" in the PostgreSQL Documentation for information on the statistics collector and views.
Values will be set for the pgx_stat_sql view in Fujitsu Enterprise Postgres if parallel query is run.
See
Refer to "D.5 pgx_stat_sql" for information on pgx_stat_sql view.
