Projection metadata

To view projection metadata for a specific projection, click the projection name in the EXPLAIN output.

To view projection metadata for a specific projection, click the projection name in the EXPLAIN output. Metadata for that projection opens in a pop-up window.

To view projection data for all projections accessed by that query, click the View Projection Metadata button at the top of the Explain page. The metadata for all projections opens in a new browser window.

The projection metadata includes the following information:

  • Projection ID

  • Schema name

  • Whether or not it is a superprojection

  • Sort columns

  • IDs of the nodes the projection is stored on

  • Whether or not it is segmented

  • Whether or not it is up to date

  • Whether or not it has statistics

  • Owner name

  • Anchor table name

To display a SQL script that can recreate the projection on a different cluster, click Click to get export data. This script is identical to the output of the EXPORT_OBJECTS function. The SQL script opens in a pop-up window.

Copy and paste the command from this window, and click Close.