FCT_PLD_QUERY_HIST_INSIGHT

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SERVER_NAME CHARACTER VARYING(50) 50
2 NPSID INTEGER 4
3 NPSINSTANCEID INTEGER 4
4 OPID BIGINT 8
5 LOGENTRYID BIGINT 8
6 QUERY_CHECKSUM CHARACTER(32) 32
7 PLANID INTEGER 4
8 CTAS_FLAG INTEGER 4
9 METADATA_QUERY INTEGER 4
10 VERBOSE_STATUS CHARACTER VARYING(18) 18
11 SESSIONID BIGINT 8
12 CURRENTUSERNAME NATIONAL CHARACTER VARYING(128) 128
13 DBNAME NATIONAL CHARACTER VARYING(128) 128
14 ENVIRONMENT CHARACTER(1) 1
15 PRIORITY INTEGER 4
16 ESTIMATEDCOST DOUBLE PRECISION 8
17 ESTIMATEDDISK NUMERIC(38,0) 19
18 ESTIMATEDMEM NUMERIC(38,0) 19
19 SUBMITTIME TIMESTAMP 8
20 SUBMITDATE DATE 4
21 SUBMITDOW BIGINT 8
22 SUBMITTOD TIME 8
23 SUBMITHOD BIGINT 8
24 STARTTIME TIMESTAMP 8
25 STARTDATE DATE 4
26 STARTDOW BIGINT 8
27 STARTTOD TIME 8
28 STARTHOD BIGINT 8
29 FINISHTIME TIMESTAMP 8
30 FINISHDATE DATE 4
31 FINISHDOW BIGINT 8
32 FINISHTOD TIME 8
33 FINISHHOD BIGINT 8
34 QUEUED_SECONDS NUMERIC(38,6) 19
35 RUNTIME_SECONDS NUMERIC(38,6) 19
36 ELAPSE_SECONDS NUMERIC(38,6) 19
37 RESULTROWS BIGINT 8
38 RESULTBYTES BIGINT 8
39 TOTALSNIPPETS BIGINT 8
40 NUMPLANS BIGINT 8
41 NUMRESTARTS NUMERIC(38,0) 19
42 CNT INTEGER 4
43 QUERY NATIONAL CHARACTER VARYING(8192) 8192
44 FULLNAME NATIONAL CHARACTER VARYING(128) 128
45 USERCOMPANY CHARACTER VARYING(64) 64
46 USERDEPARTMENT1 CHARACTER VARYING(64) 64
47 USERDEPARTMENT2 CHARACTER VARYING(64) 64
48 USERDEPARTMENT3 CHARACTER VARYING(64) 64
49 USERLOCATION CHARACTER VARYING(64) 64
50 HCPU NUMERIC(38,6) 19
51 AVG_CPU NUMERIC(38,6) 19
52 MAX_CPU NUMERIC(38,6) 19
53 AVG_DWRITE NUMERIC(38,6) 19
54 MAX_DWRITE NUMERIC(38,6) 19
55 AVG_DREAD NUMERIC(38,6) 19
56 MAX_DREAD NUMERIC(38,6) 19
57 AVG_TWRITE NUMERIC(38,6) 19
58 MAX_TWRITE NUMERIC(38,6) 19
59 MAX_TREAD NUMERIC(38,6) 19
60 AVG_FABRIC NUMERIC(38,6) 19
61 MAX_FABRIC NUMERIC(38,6) 19
62 IOWAIT NUMERIC(38,6) 19
63 GRA CHARACTER VARYING(64) 64
64 WEIGHT NUMERIC(38,6) 19
65 COST NUMERIC(38,12) 19