-
Notifications
You must be signed in to change notification settings - Fork 158
Closed
Description
Background [Optional]
Hi
We are writing AQLs on Arango Spline db to read the execution plan in tabular format and could not find certain fields like
1.) "Type" (JDBC)
2.) "Destination" of "type" for jdbc, jdbc string shows on UI but could not figure which collection has this information.
3.) "Executed at" on spline UI
Question
Is there a document mapping Arango collection attributes to Spline UI.
AQL:
FOR a in operation
FOR doc IN executionPlan
FOR b in progressOf
FOR c in progress
FILTER (DATE_FORMAT(DATE_ISO8601(a._created),"%yyyy-%mm-%dd")=='2022-03-21'
OR DATE_FORMAT(DATE_ISO8601(a._created),"%yyyy-%mm-%dd")=='2022-03-22')
AND doc._id==a._belongsTo
AND doc._id==b._to
AND b._from==c._id
SORT a._id desc
RETURN DISTINCT {
"datev" : DATE_FORMAT(DATE_FORMAT(DATE_ISO8601(a._created),"%yyyy-%mm-%dd %hh:%mm:%ss"),"%yyyy-%mm-%dd"),
"appName" : doc.name,
"sourceType" : a.extra.sourceType,
"inputSources" : a.inputSources,
"appId" : c.extra.appId,
"id" : doc._id,
"operation_name": a.name,
"operation_id" : execution._id,
"writeCnt" : c.extra.writeMetrics.numOutputRows,
"duration" : c.durationNs,
"param" : a.params
}
Thanks
Abhineet
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels
Type
Projects
Status
Done