# SHOW DISTRIBUTED\_PLANCACHE STATUS

> **📝 Note**: This is a Preview feature.

Provides information about the status and performance of the [Distributed Plancache](https://docs.singlestore.com/cloud/user-and-workspace-administration/workspace-health-and-performance/distributed-plancache.md).

This command provides statistics for the node on which it is run.

The following table describes the metrics returned by the `SHOW DISTRIBUTED_PLANCACHE STATUS` command.

| Metric(s)                                                                                                                                                | Description                                                                                                                                                              |
| -------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| Successful Downloads Since StartupSkipped Downloads Since StartupFailed Downloads Since Startup                                                          | The number of successful, skipped, and failed plan downloads from the DPC to the local PPC since startup.                                                                |
| Plans Uploaded Since Startup                                                                                                                             | The number of plans uploaded from the local PPC to the DPC since the startup.                                                                                            |
| Plans Deleted Since Startup                                                                                                                              | The number of plans the node has deleted from the DPC since startup.                                                                                                     |
| DB Synchronizations Since Startup                                                                                                                        | The number of synchronization tasks (manual or automated) that this node has performed since startup.                                                                    |
| Successful Downloads From Periodic Sync Since StartupSkipped Downloads From Periodic Sync Since StartupFailed Downloads From Periodic Sync Since Startup | The number of successful, skipped, and failed downloads that occurred during the periodic aggregator synchronizations since startup.Applicable to aggregator nodes only. |
| Periodic Query Plan Syncs Since Startup                                                                                                                  | The number of periodic aggregator synchronizations since startup.Applicable to aggregator nodes only.                                                                    |
| Distributed Plancache Plans Used Since Startup                                                                                                           | The number of plans loaded into memory from the PPC, which originated from the DPC. Tracks how effective the DPC has been in saving re-compilations.                     |
| Currently Queued Populate Download TasksCurrently Queued Download TasksCurrently Queued Upload TasksCurrently Queued Delete Tasks                        | These metrics indicate the number of tasks queued in the DPC task queue.                                                                                                 |
| Avg Plan Download Latency (ms)Avg Plan Upload Latency (ms)Avg Plan Delete Latency (ms)                                                                   | The average latency (in milliseconds) from cloud storage.                                                                                                                |
| Avg Duration For DB Plan Synchronization (ms)                                                                                                            | Indicates the average length of a synchronization task.                                                                                                                  |

Sample output of the `SHOW DISTRIBUTED_PLANCACHE STATUS` command:

```sql
SHOW DISTRIBUTED_PLANCACHE STATUS;

```

```output

+-------------------------------------------------------+-------+
| Stat                                                  | Value |
+-------------------------------------------------------+-------+
| Successful Downloads Since Startup                    |  2341 |
| Skipped Downloads Since Startup                       |    45 |
| Failed Downloads Since Startup                        |    12 |
| Plans Uploaded Since Startup                          |   112 |
| Plans Deleted Since Startup                           |    65 |
| DB Synchronizations Since Startup                     |     7 |
| Successful Downloads From Periodic Sync Since Startup |    12 | 
| Skipped Downloads From Periodic Sync Since Startup    |   107 | 
| Failed Downloads From Periodic Sync Since Startup     |     0 | 
| Periodic Query Plan Syncs Since Startup               |     1 | 
| Distributed Plancache Plans Used Since Startup        |    90 |
| Currently Queued Populate Download Tasks              |     2 |
| Currently Queued Download Tasks                       |     6 |
| Currently Queued Upload Tasks                         |    33 |
| Currently Queued Delete Tasks                         |    23 |
| Avg Plan Download Latency (ms)                        |    55 |
| Avg Plan Upload Latency (ms)                          |    33 |
| Avg Plan Delete Latency (ms)                          |    43 |
| Avg Duration For DB Plan Synchronization (ms)         | 11231 |
+-------------------------------------------------------+-------+

```

***

Modified at: October 1, 2025

Source: [/cloud/reference/sql-reference/show-commands/show-distributed-plancache-status/](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-distributed-plancache-status/)

(An index of the documentation is available at /llms.txt)