> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SHOW FUNCTION STATUS

Outputs the status of one or more running, or previously running,
[UDFs/UDTFs](https://docs.kinetica.com/content/sql/udf.md#sql-udf).  Users with `SYSTEM ADMIN` or `ADMIN`
permission on all UDFs will see all current & historical UDF runs, while users
with `EXECUTE` or `ADMIN` permissions on individual UDFs will only see the
current & historical runs for UDFs/UDTFs that they have executed themselves.
Historical run data is preserved when a UDF/UDTF is executed with the
`KI_HINT_SAVE_UDF_STATS` hint.

```sql title="SHOW FUNCTION STATUS Syntax" theme={null}
SHOW FUNCTION STATUS [VERBOSE] [FOR '<run ID>']
```

## Parameters

> [accordion] VERBOSE
>
> Specifies verbose output mode.  This modifies the response as noted below.

> [accordion] FOR '\<run ID>'
>
> Specifies that only the status of UDF/UDTF execution with run ID `<run ID>` should be output.

> [!NOTE]
>
> The response to `SHOW FUNCTION STATUS` depends on whether the
> `VERBOSE` option was specified.
>
> * No `VERBOSE` - output is a three-column result set:
>
>   * `FUNCTION_NAME` - name of the UDF/UDTF
>   * `RUN_ID` - ID associated with a given execution of the UDF/UDTF
>   * `OVERALL_STATUS` - completion status of UDF/UDTF
> * `VERBOSE` - output is a single-column, single-row result set with a list
>   of all UDF/UDTF statuses, each as a formatted block of information in the
>   `FUNCTION_STATUSES` column

## Examples

To show the status of all UDF/UDTF runs:

```sql SHOW FUNCTION STATUS Example theme={null}
SHOW FUNCTION STATUS
```

To show the verbose status of a UDF/UDTF with run ID *1000*:

```sql SHOW FUNCTION STATUS By Run ID Example theme={null}
SHOW FUNCTION STATUS VERBOSE FOR '1000'
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.