Request a Demo
46.4. Statistics Collection Processes
Prev UpChapter 46. ActivityHome Next

46.4. Statistics Collection Processes #

46.4.1. Viewing Statistics Collection Processes
46.4.2. Canceling a Statistics Collection Process
46.4.3. Terminating the User Session for a Statistics Collection Process

You can view information about statistics collection processes for the planner (ANALYZE). The information is based on the pg_stat_progress_analyze view.

46.4.1. Viewing Statistics Collection Processes #

Go to statistic collection processes in one of the following ways:

  • Using the monitoring section:

    1. In the navigation panel, go to Monitoring → Activity.

    2. Select Analyzing, and then in the top-right corner of the page, select the instance and database.

  • Using the configuration section of an instance:

    1. In the navigation panel, go to Infrastructure → Instances.

    2. Click the name of the instance.

    3. In the navigation panel, go to Activity.

    4. Select Analyzing, and then in the top-right corner of the page, select the database.

The table of statistics collection processes with the following columns will be displayed:

  • PID: The ID of the backend.

  • State: The state of the backend.

    For more information about possible values, refer to the official Postgres Pro documentation on the pg_stat_activity module (refer to the state column).

  • Wait event: The name and type of the wait event for the backend.

    For more information, refer to the official Postgres Pro documentation on the pg_stat_activity module (refer to wait_event_type and wait_event columns).

  • Phase: The statistics collection phase.

    For more information about possible values, refer to the official Postgres Pro documentation.

  • Database: The name of the database where the statistics collection is performed.

  • User: The name of the DBMS user on behalf of which the statistics are being collected.

  • Table: The name or ID of the table for which the statistics are being collected.

  • Query: The text of the current or last backend query.

  • Query duration: The duration of the current or last backend query.

  • Current child table: The name of the child table for which the statistics are being collected.

  • Child tables done: The number of child tables for which the statistics were collected.

  • Child tables total: The total number of the child tables for which statistics must be collected.

  • Scanned, %: The percentage of data scanned in the tables for which statistics are being collected.

  • Sample size: The size of the sample used for statistics collection.

  • Stat total: The total number of extended statistics objects.

  • Stat computed: The number of computed extended statistics objects.

  • Actions.

    For more information about available actions, refer to the corresponding instructions.

46.4.2. Canceling a Statistics Collection Process #

Canceling a statistics collection process does not terminate a user session.

To cancel a statistics collection process:

  1. Go to statistic collection processes in one of the following ways:

    • Using the monitoring section:

      1. In the navigation panel, go to Monitoring → Activity.

      2. Select Analyzing, and then in the top-right corner of the page, select the instance and database.

    • Using the configuration section of an instance:

      1. In the navigation panel, go to Infrastructure → Instances.

      2. Click the name of the instance.

      3. In the navigation panel, go to Activity.

      4. Select Analyzing, and then in the top-right corner of the page, select the database.

  2. Click Cancel current request next to the statistics collection process.

  3. Click Execute.

46.4.3. Terminating the User Session for a Statistics Collection Process #

When the user session is terminated, the statistics collection process is canceled automatically.

To terminate the user session for a statistics collection process:

  1. Go to statistic collection processes in one of the following ways:

    • Using the monitoring section:

      1. In the navigation panel, go to Monitoring → Activity.

      2. Select Analyzing, and then in the top-right corner of the page, select the instance and database.

    • Using the configuration section of an instance:

      1. In the navigation panel, go to Infrastructure → Instances.

      2. Click the name of the instance.

      3. In the navigation panel, go to Activity.

      4. Select Analyzing, and then in the top-right corner of the page, select the database.

  2. Click Cancel session next to the statistics collection process.

  3. Click Execute.

Prev Up Next
46.3. Vacuum Processes Home 46.5. Clustering Processes
epub pdf