[DRILL-4258] Create New SYS tables: cpu, queries, fragments, threads, threadtraces, connections

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Execution - Monitoring
• Assignee: Unassigned
• Reporter: Jacques Nadeau
• Created: 10/Jan/16 02:19
• Updated: 02/May/17 20:56

Description

cpu: Drillbit, # Cores, CPU consumption (with different windows?)
queries: Foreman, QueryId, User, SQL, Start Time, rows processed, query plan, # nodes involved, number of running fragments, memory consumed
fragments: Drillbit, queryid, major fragmentid, minorfragmentid, coordinate, memory usage, rows processed, start time
threads: name, priority, state, id, thread-level cpu stats
threadtraces: threads, stack trace
connections: client, server, type, establishedDate, messagesSent, bytesSent

Sub-Tasks

• Create a sys.queries table: Open
• Create a sys.fragments table: Open
• Create a sys.functions table to expose available Drill functions: Resolved
• Create a sys.connections table: Closed
• Create a system table for completed profiles - sys.profiles: Closed