STL_INSERT
Analyzes insert execution steps for queries.
This view is visible to all users. Superusers can see all rows; regular users can see only their own data. For more information, see Visibility of data in system tables and views.
Table columns
Column name | Data type | Description |
---|---|---|
userid | integer | ID of the user who generated the entry. |
query | integer | Query ID. The query column can be used to join other system tables and views. |
slice | integer | Number that identifies the slice where the query was running. |
segment | integer | Number that identifies the query segment. |
step | integer | Query step that ran. |
starttime | timestamp | Time in UTC that the query started. Total time includes queuing and execution. with 6 digits of precision for fractional seconds. For example: 2009-06-12 11:29:19.131358 . |
endtime | timestamp | Time in UTC that the query finished. Total time includes queuing and execution. with 6 digits of precision for fractional seconds. For example: 2009-06-12 11:29:19.131358 . |
tasknum | integer | Number of the query task process that was assigned to run the step. |
rows | bigint | Total number of rows that were processed. |
tbl | integer | Table ID. |
Sample queries
The following example returns insert execution steps for the most recent query.
select slice, segment, step, tasknum, rows, tbl from stl_insert where query=pg_last_query_id();
slice | segment | step | tasknum | rows | tbl -------+---------+------+---------+-------+-------- 0 | 2 | 2 | 15 | 24958 | 100548 1 | 2 | 2 | 15 | 25032 | 100548 (2 rows)