uptrace 1.3.0 sqlite dump

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE bun_migrations ("id" INTEGER NOT NULL, "name" VARCHAR, "group_id" INTEGER, "migrated_at" TIMESTAMP NOT NULL DEFAULT current_timestamp, PRIMARY KEY ("id"));
INSERT INTO "bun_migrations" VALUES(1,'20220926100948',1,'2023-01-29 05:15:20');
INSERT INTO "bun_migrations" VALUES(2,'20220926101947',1,'2023-01-29 05:15:20');
CREATE TABLE bun_migration_locks ("id" INTEGER NOT NULL, "table_name" VARCHAR, PRIMARY KEY ("id"), UNIQUE ("table_name"));
CREATE TABLE "metrics" ("id" INTEGER NOT NULL, "project_id" INTEGER, "name" VARCHAR, "description" VARCHAR, "unit" VARCHAR, "instrument" VARCHAR, "created_at" TIMESTAMP DEFAULT CURRENT_TIMESTAMP, "updated_at" TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY ("id"));
INSERT INTO "metrics" VALUES(1,1,'uptrace.tracing.spans','Spans duration (excluding events)','microseconds','histogram','2023-01-29 05:15:19.062477+00:00','2023-01-29 05:15:19.062477+00:00');
INSERT INTO "metrics" VALUES(2,2,'uptrace.tracing.spans','Spans duration (excluding events)','microseconds','histogram','2023-01-29 05:15:19.064386+00:00','2023-01-29 05:15:19.064386+00:00');
INSERT INTO "metrics" VALUES(3,3,'uptrace.tracing.spans','Spans duration (excluding events)','microseconds','histogram','2023-01-29 05:15:19.066+00:00','2023-01-29 05:15:19.066+00:00');
INSERT INTO "metrics" VALUES(4,4,'uptrace.tracing.spans','Spans duration (excluding events)','microseconds','histogram','2023-01-29 05:15:19.067595+00:00','2023-01-29 05:15:19.067595+00:00');
INSERT INTO "metrics" VALUES(5,1,'uptrace.tracing.events','Events count (excluding spans)','1','counter','2023-01-29 05:15:19.085723+00:00','2023-01-29 05:15:19.085723+00:00');
INSERT INTO "metrics" VALUES(6,2,'uptrace.tracing.events','Events count (excluding spans)','1','counter','2023-01-29 05:15:19.087858+00:00','2023-01-29 05:15:19.087858+00:00');
INSERT INTO "metrics" VALUES(7,3,'uptrace.tracing.events','Events count (excluding spans)','1','counter','2023-01-29 05:15:19.089661+00:00','2023-01-29 05:15:19.089661+00:00');
INSERT INTO "metrics" VALUES(8,4,'uptrace.tracing.events','Events count (excluding spans)','1','counter','2023-01-29 05:15:19.091522+00:00','2023-01-29 05:15:19.091522+00:00');
INSERT INTO "metrics" VALUES(9,1,'uptrace.projects.spans','Number of processed spans',NULL,'counter','2023-01-29 05:15:34.012323+00:00','2023-01-29 05:15:34.012323+00:00');
INSERT INTO "metrics" VALUES(10,1,'uptrace.spans.buffer_size','',NULL,'gauge','2023-01-29 05:15:34.015918+00:00','2023-01-29 05:15:34.015918+00:00');
INSERT INTO "metrics" VALUES(11,1,'uptrace.measures.buffer_size','',NULL,'gauge','2023-01-29 05:15:34.017782+00:00','2023-01-29 05:15:34.017782+00:00');
INSERT INTO "metrics" VALUES(12,1,'go.sql.connections_max_open','Maximum number of open connections to the database',NULL,'gauge','2023-01-29 05:15:34.019625+00:00','2023-01-29 05:15:34.019625+00:00');
INSERT INTO "metrics" VALUES(13,1,'go.sql.connections_open','The number of established connections both in use and idle',NULL,'gauge','2023-01-29 05:15:34.021428+00:00','2023-01-29 05:15:34.021428+00:00');
INSERT INTO "metrics" VALUES(14,1,'go.sql.connections_in_use','The number of connections currently in use',NULL,'gauge','2023-01-29 05:15:34.023278+00:00','2023-01-29 05:15:34.023278+00:00');
INSERT INTO "metrics" VALUES(15,1,'go.sql.connections_idle','The number of idle connections',NULL,'gauge','2023-01-29 05:15:34.024937+00:00','2023-01-29 05:15:34.024937+00:00');
INSERT INTO "metrics" VALUES(16,1,'go.sql.connections_wait_count','The total number of connections waited for',NULL,'counter','2023-01-29 05:15:34.026576+00:00','2023-01-29 05:15:34.026576+00:00');
INSERT INTO "metrics" VALUES(17,1,'go.sql.connections_wait_duration','The total time blocked waiting for a new connection','nanoseconds','counter','2023-01-29 05:15:34.02828+00:00','2023-01-29 05:15:34.02828+00:00');
INSERT INTO "metrics" VALUES(18,1,'go.sql.connections_closed_max_idle','The total number of connections closed due to SetMaxIdleConns',NULL,'counter','2023-01-29 05:15:34.029873+00:00','2023-01-29 05:15:34.029873+00:00');
INSERT INTO "metrics" VALUES(19,1,'go.sql.connections_closed_max_idle_time','The total number of connections closed due to SetConnMaxIdleTime',NULL,'counter','2023-01-29 05:15:34.03161+00:00','2023-01-29 05:15:34.03161+00:00');
INSERT INTO "metrics" VALUES(20,1,'go.sql.connections_closed_max_lifetime','The total number of connections closed due to SetConnMaxLifetime',NULL,'counter','2023-01-29 05:15:34.033308+00:00','2023-01-29 05:15:34.033308+00:00');
INSERT INTO "metrics" VALUES(21,1,'runtime.uptime','Milliseconds since application was initialized','milliseconds','additive','2023-01-29 05:15:34.03487+00:00','2023-01-29 05:15:34.03487+00:00');
INSERT INTO "metrics" VALUES(22,1,'process.runtime.go.goroutines','Number of goroutines that currently exist',NULL,'additive','2023-01-29 05:15:34.036396+00:00','2023-01-29 05:15:34.036396+00:00');
INSERT INTO "metrics" VALUES(23,1,'process.runtime.go.cgo.calls','Number of cgo calls made by the current process',NULL,'additive','2023-01-29 05:15:34.037775+00:00','2023-01-29 05:15:34.037775+00:00');
INSERT INTO "metrics" VALUES(24,1,'process.runtime.go.mem.heap_alloc','Bytes of allocated heap objects','bytes','additive','2023-01-29 05:15:34.039294+00:00','2023-01-29 05:15:34.039294+00:00');
INSERT INTO "metrics" VALUES(25,1,'process.runtime.go.mem.heap_idle','Bytes in idle (unused) spans','bytes','additive','2023-01-29 05:15:34.040684+00:00','2023-01-29 05:15:34.040684+00:00');
INSERT INTO "metrics" VALUES(26,1,'process.runtime.go.mem.heap_inuse','Bytes in in-use spans','bytes','additive','2023-01-29 05:15:34.042165+00:00','2023-01-29 05:15:34.042165+00:00');
INSERT INTO "metrics" VALUES(27,1,'process.runtime.go.mem.heap_objects','Number of allocated heap objects',NULL,'additive','2023-01-29 05:15:34.043554+00:00','2023-01-29 05:15:34.043554+00:00');
INSERT INTO "metrics" VALUES(28,1,'process.runtime.go.mem.heap_released','Bytes of idle spans whose physical memory has been returned to the OS','bytes','additive','2023-01-29 05:15:34.045052+00:00','2023-01-29 05:15:34.045052+00:00');
INSERT INTO "metrics" VALUES(29,1,'process.runtime.go.mem.heap_sys','Bytes of heap memory obtained from the OS','bytes','additive','2023-01-29 05:15:34.04645+00:00','2023-01-29 05:15:34.04645+00:00');
INSERT INTO "metrics" VALUES(30,1,'process.runtime.go.mem.lookups','Number of pointer lookups performed by the runtime',NULL,'counter','2023-01-29 05:15:34.047746+00:00','2023-01-29 05:15:34.047746+00:00');
INSERT INTO "metrics" VALUES(31,1,'process.runtime.go.mem.live_objects','Number of live objects is the number of cumulative Mallocs - Frees',NULL,'additive','2023-01-29 05:15:34.049176+00:00','2023-01-29 05:15:34.049176+00:00');
INSERT INTO "metrics" VALUES(32,1,'process.runtime.go.gc.count','Number of completed garbage collection cycles',NULL,'counter','2023-01-29 05:15:34.050499+00:00','2023-01-29 05:15:34.050499+00:00');
INSERT INTO "metrics" VALUES(33,1,'process.runtime.go.gc.pause_total_ns','Cumulative nanoseconds in GC stop-the-world pauses since the program started',NULL,'counter','2023-01-29 05:15:34.05179+00:00','2023-01-29 05:15:34.05179+00:00');
INSERT INTO "metrics" VALUES(34,1,'process.runtime.go.gc.pause_ns','Amount of nanoseconds in GC stop-the-world pauses',NULL,'histogram','2023-01-29 05:15:34.053184+00:00','2023-01-29 05:15:34.053184+00:00');
INSERT INTO "metrics" VALUES(35,1,'go.sql.query_timing','Timing of processed queries','milliseconds','histogram','2023-01-29 05:15:34.054497+00:00','2023-01-29 05:15:34.054497+00:00');
INSERT INTO "metrics" VALUES(36,1,'uptrace.projects.measures','Number of processed measures',NULL,'counter','2023-01-29 05:15:49.004825+00:00','2023-01-29 05:15:49.004825+00:00');
INSERT INTO "metrics" VALUES(37,1,'http.server.request_content_length','',NULL,'counter','2023-01-29 05:16:04.00933+00:00','2023-01-29 05:16:04.00933+00:00');
INSERT INTO "metrics" VALUES(38,1,'http.server.response_content_length','',NULL,'counter','2023-01-29 05:16:04.014116+00:00','2023-01-29 05:16:04.014116+00:00');
INSERT INTO "metrics" VALUES(39,1,'http.server.duration','',NULL,'histogram','2023-01-29 05:16:04.018658+00:00','2023-01-29 05:16:04.018658+00:00');
INSERT INTO "metrics" VALUES(40,4,'http.server.active_requests','measures the number of concurrent HTTP requests those are currently in flight','requests','additive','2023-01-29 05:19:06.793155+00:00','2023-01-29 05:19:06.793155+00:00');
INSERT INTO "metrics" VALUES(41,4,'http.server.duration','measures the duration of the inbound http request','milliseconds','histogram','2023-01-29 05:19:06.7964+00:00','2023-01-29 05:19:06.7964+00:00');
INSERT INTO "metrics" VALUES(42,4,'task_started','',NULL,'counter','2023-01-29 05:22:43.849384+00:00','2023-01-29 05:22:43.849384+00:00');
INSERT INTO "metrics" VALUES(43,4,'task_unknown_error','',NULL,'counter','2023-01-29 05:22:43.851502+00:00','2023-01-29 05:22:43.851502+00:00');
INSERT INTO "metrics" VALUES(44,4,'task_success','',NULL,'counter','2023-01-29 05:22:43.852938+00:00','2023-01-29 05:22:43.852938+00:00');
INSERT INTO "metrics" VALUES(45,4,'task_already_running','',NULL,'counter','2023-01-29 05:22:43.85445+00:00','2023-01-29 05:22:43.85445+00:00');
INSERT INTO "metrics" VALUES(46,4,'task_missing_dependency','',NULL,'counter','2023-01-29 05:23:17.921134+00:00','2023-01-29 05:23:17.921134+00:00');
INSERT INTO "metrics" VALUES(47,4,'task_broken','',NULL,'counter','2023-01-29 05:51:49.340564+00:00','2023-01-29 05:51:49.340564+00:00');
INSERT INTO "metrics" VALUES(48,4,'task_not_found','',NULL,'counter','2023-01-29 07:39:54.523181+00:00','2023-01-29 07:39:54.523181+00:00');
INSERT INTO "metrics" VALUES(49,4,'api_collection_view','',NULL,'counter','2023-01-30 10:22:34.721025+00:00','2023-01-30 10:22:34.721025+00:00');
CREATE TABLE "dashboards" ("id" INTEGER NOT NULL, "project_id" INTEGER, "template_id" VARCHAR, "name" VARCHAR, "base_query" VARCHAR, "is_table" BOOLEAN, "metrics" VARCHAR, "query" VARCHAR, "columns" VARCHAR, PRIMARY KEY ("id"));
INSERT INTO "dashboards" VALUES(1,2,'uptrace.collector.spans_by_system','Uptrace: spans by system',NULL,1,'[{"name":"uptrace.tracing.spans","alias":"spans"}]','group by span.system | per_min($spans) as spans_per_min | count($spans{span.status_code=''error''}) / count($spans) as error_rate | p50($spans) as p50 | p90($spans) as p90 | p99($spans) as p99 | max($spans) as max','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dashboards" VALUES(2,3,'uptrace.collector.spans_by_system','Uptrace: spans by system',NULL,1,'[{"name":"uptrace.tracing.spans","alias":"spans"}]','group by span.system | per_min($spans) as spans_per_min | count($spans{span.status_code=''error''}) / count($spans) as error_rate | p50($spans) as p50 | p90($spans) as p90 | p99($spans) as p99 | max($spans) as max','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dashboards" VALUES(3,2,'uptrace.spans_by_service','Uptrace: spans by service',NULL,1,'[{"name":"uptrace.tracing.spans","alias":"spans"}]','group by service.name | per_min($spans) as spans_per_min | count($spans{span.status_code=''error''}) / count($spans) as error_rate | p50($spans) as p50 | p90($spans) as p90 | p99($spans) as p99 | max($spans) as max','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dashboards" VALUES(4,3,'uptrace.spans_by_service','Uptrace: spans by service',NULL,1,'[{"name":"uptrace.tracing.spans","alias":"spans"}]','group by service.name | per_min($spans) as spans_per_min | count($spans{span.status_code=''error''}) / count($spans) as error_rate | p50($spans) as p50 | p90($spans) as p90 | p99($spans) as p99 | max($spans) as max','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dashboards" VALUES(5,4,'uptrace.collector.spans_by_system','Uptrace: spans by system',NULL,1,'[{"name":"uptrace.tracing.spans","alias":"spans"}]','group by span.system | per_min($spans) as spans_per_min | count($spans{span.status_code=''error''}) / count($spans) as error_rate | p50($spans) as p50 | p90($spans) as p90 | p99($spans) as p99 | max($spans) as max','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dashboards" VALUES(6,3,'uptrace.spans_by_host','Uptrace: spans by host',NULL,1,'[{"name":"uptrace.tracing.spans","alias":"spans"}]','group by host.name | per_min($spans) as spans_per_min | count($spans{span.status_code=''error''}) / count($spans) as error_rate | p50($spans) as p50 | p90($spans) as p90 | p99($spans) as p99 | max($spans) as max','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dashboards" VALUES(7,2,'uptrace.spans_by_host','Uptrace: spans by host',NULL,1,'[{"name":"uptrace.tracing.spans","alias":"spans"}]','group by host.name | per_min($spans) as spans_per_min | count($spans{span.status_code=''error''}) / count($spans) as error_rate | p50($spans) as p50 | p90($spans) as p90 | p99($spans) as p99 | max($spans) as max','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dashboards" VALUES(8,4,'uptrace.spans_by_service','Uptrace: spans by service',NULL,1,'[{"name":"uptrace.tracing.spans","alias":"spans"}]','group by service.name | per_min($spans) as spans_per_min | count($spans{span.status_code=''error''}) / count($spans) as error_rate | p50($spans) as p50 | p90($spans) as p90 | p99($spans) as p99 | max($spans) as max','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dashboards" VALUES(9,4,'uptrace.spans_by_host','Uptrace: spans by host',NULL,1,'[{"name":"uptrace.tracing.spans","alias":"spans"}]','group by host.name | per_min($spans) as spans_per_min | count($spans{span.status_code=''error''}) / count($spans) as error_rate | p50($spans) as p50 | p90($spans) as p90 | p99($spans) as p99 | max($spans) as max','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dashboards" VALUES(10,1,'uptrace.go.runtime_by_service_host','Go: Runtime',NULL,1,'[{"name":"process.runtime.go.gc.pause_ns","alias":"gc_pause"},{"name":"process.runtime.go.mem.heap_inuse","alias":"mem_in_use"},{"name":"process.runtime.go.mem.heap_objects","alias":"heap_objects"},{"name":"process.runtime.go.goroutines","alias":"goroutines"}]','group by service.name | group by host.name | max($gc_pause) as gc_pause_max | $mem_in_use | $heap_objects | $goroutines','{"gc_pause_max":{"unit":"nanoseconds"}}');
INSERT INTO "dashboards" VALUES(11,1,'uptrace.go.sql_client_by_service_host','Go: SQL client',NULL,1,'[{"name":"go.sql.query_timing","alias":"query_timing"},{"name":"go.sql.connections_open","alias":"conns_open"}]','group by service.name | group by host.name | per_min($query_timing) as queries | p90($query_timing) as timing_p90 | p99($query_timing) as timing_p99 | $conns_open','{"timing_p90":{"unit":"milliseconds"},"timing_p99":{"unit":"milliseconds"}}');
INSERT INTO "dashboards" VALUES(12,1,'uptrace.collector.projects','Uptrace: collector stats by project',NULL,1,'[{"name":"uptrace.projects.spans","alias":"spans"},{"name":"uptrace.projects.measures","alias":"measures"}]','group by project_id | per_min($spans) as spans_per_min | per_min($measures) as measures_per_min','{}');
INSERT INTO "dashboards" VALUES(13,1,'uptrace.collector.hosts','Uptrace: collector stats by host',NULL,NULL,'[]',NULL,'{}');
INSERT INTO "dashboards" VALUES(14,1,'uptrace.collector.spans_by_system','Uptrace: spans by system',NULL,1,'[{"name":"uptrace.tracing.spans","alias":"spans"}]','group by span.system | per_min($spans) as spans_per_min | count($spans{span.status_code=''error''}) / count($spans) as error_rate | p50($spans) as p50 | p90($spans) as p90 | p99($spans) as p99 | max($spans) as max','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dashboards" VALUES(15,1,'uptrace.spans_by_service','Uptrace: spans by service',NULL,1,'[{"name":"uptrace.tracing.spans","alias":"spans"}]','group by service.name | per_min($spans) as spans_per_min | count($spans{span.status_code=''error''}) / count($spans) as error_rate | p50($spans) as p50 | p90($spans) as p90 | p99($spans) as p99 | max($spans) as max','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dashboards" VALUES(16,1,'uptrace.spans_by_host','Uptrace: spans by host',NULL,1,'[{"name":"uptrace.tracing.spans","alias":"spans"}]','group by host.name | per_min($spans) as spans_per_min | count($spans{span.status_code=''error''}) / count($spans) as error_rate | p50($spans) as p50 | p90($spans) as p90 | p99($spans) as p99 | max($spans) as max','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dashboards" VALUES(17,1,'uptrace.http.server_by_service_host','HTTP: Server',NULL,1,'[{"name":"http.server.duration","alias":"srv_dur"},{"name":"http.server.request_content_length","alias":"req_len"},{"name":"http.server.response_content_length","alias":"resp_len"},{"name":"process.runtime.go.goroutines","alias":"goroutines"}]','group by service.name | group by host.name | per_min($srv_dur) as req_per_min | p90($srv_dur) as dur_p90 | p99($srv_dur) AS dur_p99 | per_min($req_len) as req_len | per_min($resp_len) as resp_len','{"dur_p90":{"unit":"microseconds"},"dur_p99":{"unit":"microseconds"},"req_len":{"unit":"bytes"},"resp_len":{"unit":"bytes"}}');
INSERT INTO "dashboards" VALUES(18,4,NULL,'Uptrace: spans by host clone',NULL,NULL,'[{"name":"uptrace.tracing.spans","alias":"spans"}]','group by host.name | per_min($spans) as spans_per_min | count($spans{span.status_code=''error''}) / count($spans) as error_rate | p50($spans) as p50 | p90($spans) as p90 | p99($spans) as p99 | max($spans) as max','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dashboards" VALUES(19,4,NULL,'tasks',NULL,NULL,NULL,NULL,'{}');
CREATE TABLE "dash_entries" ("id" INTEGER NOT NULL, "dash_id" INTEGER, "project_id" INTEGER, "name" VARCHAR, "description" VARCHAR, "weight" INTEGER, "chart_type" VARCHAR DEFAULT 'line', "metrics" VARCHAR, "query" VARCHAR, "columns" VARCHAR, PRIMARY KEY ("id"), FOREIGN KEY ("dash_id") REFERENCES "dashboards" ("id") ON UPDATE NO ACTION ON DELETE CASCADE);
INSERT INTO "dash_entries" VALUES(1,1,2,'Number of spans','',6,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','per_min($spans) as spans group by span.status_code','{}');
INSERT INTO "dash_entries" VALUES(2,1,2,'Error rate','',5,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','count($spans{span.status_code=''error''}) / count($spans) as error_rate','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dash_entries" VALUES(3,1,2,'P50 span duration','',4,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p50($spans)','{}');
INSERT INTO "dash_entries" VALUES(4,1,2,'P75 span duration','',3,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p75($spans)','{}');
INSERT INTO "dash_entries" VALUES(5,1,2,'P90 span duration','',2,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p90($spans)','{}');
INSERT INTO "dash_entries" VALUES(6,1,2,'Max span duration','',1,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','max($spans)','{}');
INSERT INTO "dash_entries" VALUES(7,2,3,'Number of spans','',6,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','per_min($spans) as spans group by span.status_code','{}');
INSERT INTO "dash_entries" VALUES(8,2,3,'Error rate','',5,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','count($spans{span.status_code=''error''}) / count($spans) as error_rate','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dash_entries" VALUES(9,2,3,'P50 span duration','',4,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p50($spans)','{}');
INSERT INTO "dash_entries" VALUES(10,2,3,'P75 span duration','',3,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p75($spans)','{}');
INSERT INTO "dash_entries" VALUES(11,2,3,'P90 span duration','',2,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p90($spans)','{}');
INSERT INTO "dash_entries" VALUES(12,2,3,'Max span duration','',1,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','max($spans)','{}');
INSERT INTO "dash_entries" VALUES(13,3,2,'Number of spans','',6,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','per_min($spans) as spans group by span.status_code','{}');
INSERT INTO "dash_entries" VALUES(14,3,2,'Error rate','',5,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','count($spans{span.status_code=''error''}) / count($spans) as error_rate','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dash_entries" VALUES(15,3,2,'P50 span duration','',4,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p50($spans)','{}');
INSERT INTO "dash_entries" VALUES(16,3,2,'P75 span duration','',3,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p75($spans)','{}');
INSERT INTO "dash_entries" VALUES(17,3,2,'P90 span duration','',2,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p90($spans)','{}');
INSERT INTO "dash_entries" VALUES(18,3,2,'Max span duration','',1,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','max($spans)','{}');
INSERT INTO "dash_entries" VALUES(19,4,3,'Number of spans','',6,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','per_min($spans) as spans group by span.status_code','{}');
INSERT INTO "dash_entries" VALUES(20,4,3,'Error rate','',5,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','count($spans{span.status_code=''error''}) / count($spans) as error_rate','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dash_entries" VALUES(21,4,3,'P50 span duration','',4,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p50($spans)','{}');
INSERT INTO "dash_entries" VALUES(22,4,3,'P75 span duration','',3,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p75($spans)','{}');
INSERT INTO "dash_entries" VALUES(23,4,3,'P90 span duration','',2,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p90($spans)','{}');
INSERT INTO "dash_entries" VALUES(24,4,3,'Max span duration','',1,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','max($spans)','{}');
INSERT INTO "dash_entries" VALUES(25,6,3,'Number of hosts','',6,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','per_min($spans) as spans group by span.status_code','{}');
INSERT INTO "dash_entries" VALUES(26,6,3,'Error rate','',5,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','count($spans{span.status_code=''error''}) / count($spans) as error_rate','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dash_entries" VALUES(27,6,3,'P50 span duration','',4,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p50($spans)','{}');
INSERT INTO "dash_entries" VALUES(28,6,3,'P75 span duration','',3,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p75($spans)','{}');
INSERT INTO "dash_entries" VALUES(29,6,3,'P90 span duration','',2,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p90($spans)','{}');
INSERT INTO "dash_entries" VALUES(30,6,3,'Max span duration','',1,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','max($spans)','{}');
INSERT INTO "dash_entries" VALUES(31,7,2,'Number of hosts','',6,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','per_min($spans) as spans group by span.status_code','{}');
INSERT INTO "dash_entries" VALUES(32,7,2,'Error rate','',5,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','count($spans{span.status_code=''error''}) / count($spans) as error_rate','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dash_entries" VALUES(33,7,2,'P50 span duration','',4,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p50($spans)','{}');
INSERT INTO "dash_entries" VALUES(34,7,2,'P75 span duration','',3,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p75($spans)','{}');
INSERT INTO "dash_entries" VALUES(35,7,2,'P90 span duration','',2,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p90($spans)','{}');
INSERT INTO "dash_entries" VALUES(36,7,2,'Max span duration','',1,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','max($spans)','{}');
INSERT INTO "dash_entries" VALUES(96,10,1,'Max GC stop-the-world pause','',6,'line','[{"name":"process.runtime.go.gc.pause_ns","alias":"gc_pause"}]','max($gc_pause) as gc_pause_max','{"gc_pause_max":{"unit":"nanoseconds"}}');
INSERT INTO "dash_entries" VALUES(97,10,1,'Heap memory in use','',5,'line','[{"name":"process.runtime.go.mem.heap_inuse","alias":"mem_in_use"}]','$mem_in_use','{"mem_in_use":{"unit":"bytes"}}');
INSERT INTO "dash_entries" VALUES(98,10,1,'Bytes of allocated heap objects','',4,'line','[{"name":"process.runtime.go.mem.heap_alloc","alias":"heap_alloc"}]','$heap_alloc','{"heap_alloc":{"unit":"bytes"}}');
INSERT INTO "dash_entries" VALUES(99,10,1,'Heap live objects','',3,'line','[{"name":"process.runtime.go.mem.heap_objects","alias":"heap_objects"}]','$heap_objects','{}');
INSERT INTO "dash_entries" VALUES(100,10,1,'Goroutines','',2,'line','[{"name":"process.runtime.go.goroutines","alias":"goroutines"}]','$goroutines','{}');
INSERT INTO "dash_entries" VALUES(101,10,1,'cgo calls','',1,'line','[{"name":"process.runtime.go.cgo.calls","alias":"cgo_calls"}]','delta($cgo_calls)','{}');
INSERT INTO "dash_entries" VALUES(102,11,1,'Number of queries','',9,'line','[{"name":"go.sql.query_timing","alias":"query_timing"}]','per_min($query_timing) as queries','{}');
INSERT INTO "dash_entries" VALUES(103,11,1,'Query percentiles','',8,'area','[{"name":"go.sql.query_timing","alias":"query_timing"}]','p50($query_timing) as p50 | p90($query_timing) as p90 | p99($query_timing) as p99','{"p50":{"unit":"milliseconds"},"p90":{"unit":"milliseconds"},"p99":{"unit":"milliseconds"}}');
INSERT INTO "dash_entries" VALUES(104,11,1,'Number of established connections both in use and idle','',7,'line','[{"name":"go.sql.connections_open","alias":"conns_open"}]','$conns_open','{}');
INSERT INTO "dash_entries" VALUES(105,11,1,'Number of connections currently in use','',6,'line','[{"name":"go.sql.connections_in_use","alias":"conns_in_use"}]','$conns_in_use','{}');
INSERT INTO "dash_entries" VALUES(106,11,1,'Number of idle connections','',5,'line','[{"name":"go.sql.connections_idle","alias":"conns_idle"}]','$conns_idle','{}');
INSERT INTO "dash_entries" VALUES(107,11,1,'Connection wait count and duration','',4,'line','[{"name":"go.sql.connections_wait_count","alias":"wait_count"},{"name":"go.sql.connections_wait_duration","alias":"wait_dur"}]','per_min($wait_count) as wait_count | per_min($wait_dur) as wait_dur','{"timing_p50":{"unit":"nanoseconds"}}');
INSERT INTO "dash_entries" VALUES(108,11,1,'Number of connections closed due to SetMaxIdleConns','',3,'line','[{"name":"go.sql.connections_closed_max_idle","alias":"closed_max_idle"}]','per_min($closed_max_idle) as closed_max_idle','{}');
INSERT INTO "dash_entries" VALUES(109,11,1,'Number of connections closed due to SetConnMaxIdleTime','',2,'line','[{"name":"go.sql.connections_closed_max_idle_time","alias":"closed_max_idle_time"}]','per_min($closed_max_idle_time) as closed_max_idle_time','{}');
INSERT INTO "dash_entries" VALUES(110,11,1,'Number of connections closed due to SetConnMaxLifetime','',1,'line','[{"name":"go.sql.connections_closed_max_lifetime","alias":"closed_max_lifetime"}]','per_min($closed_max_lifetime) as closed_max_lifetime','{}');
INSERT INTO "dash_entries" VALUES(111,17,1,'HTTP requests','',5,'line','[{"name":"http.server.duration","alias":"srv_dur"}]','per_min($srv_dur) as req_per_min','{}');
INSERT INTO "dash_entries" VALUES(112,17,1,'HTTP request duration','',4,'line','[{"name":"http.server.duration","alias":"srv_dur"}]','p90($srv_dur) as dur_p90 | p99($srv_dur) AS dur_p99','{"dur_p90":{"unit":"microseconds"},"dur_p99":{"unit":"microseconds"}}');
INSERT INTO "dash_entries" VALUES(113,17,1,'HTTP request length','',3,'line','[{"name":"http.server.request_content_length","alias":"req_len"}]','per_min($req_len) as req_len','{"req_len":{"unit":"bytes"}}');
INSERT INTO "dash_entries" VALUES(114,17,1,'HTTP response length','',2,'line','[{"name":"http.server.response_content_length","alias":"resp_len"}]','per_min($resp_len) as resp_len','{"resp_len":{"unit":"bytes"}}');
INSERT INTO "dash_entries" VALUES(115,17,1,'Goroutines','',1,'line','[{"name":"process.runtime.go.goroutines","alias":"goroutines"}]','$goroutines','{}');
INSERT INTO "dash_entries" VALUES(116,12,1,'Number of processed spans','',4,'line','[{"name":"uptrace.projects.spans","alias":"spans"}]','per_min($spans) group by type','{}');
INSERT INTO "dash_entries" VALUES(117,12,1,'Spans buffer size','',3,'line','[{"name":"uptrace.spans.buffer_size","alias":"spans_buffer"}]','$spans_buffer','{}');
INSERT INTO "dash_entries" VALUES(118,12,1,'Number of processed measures','',2,'line','[{"name":"uptrace.projects.measures","alias":"measures"}]','per_min($measures) group by type','{}');
INSERT INTO "dash_entries" VALUES(119,12,1,'Measures buffer size','',1,'line','[{"name":"uptrace.measures.buffer_size","alias":"measures_buffer"}]','$measures_buffer','{}');
INSERT INTO "dash_entries" VALUES(120,13,1,'Number of processed spans','',4,'line','[{"name":"uptrace.projects.spans","alias":"spans"}]','per_min($spans) group by type','{}');
INSERT INTO "dash_entries" VALUES(121,13,1,'Spans buffer size','',3,'line','[{"name":"uptrace.spans.buffer_size","alias":"spans_buffer"}]','$spans_buffer','{}');
INSERT INTO "dash_entries" VALUES(122,13,1,'Number of processed measures','',2,'line','[{"name":"uptrace.projects.measures","alias":"measures"}]','per_min($measures) group by type','{}');
INSERT INTO "dash_entries" VALUES(123,13,1,'Measures buffer size','',1,'line','[{"name":"uptrace.measures.buffer_size","alias":"measures_buffer"}]','$measures_buffer','{}');
INSERT INTO "dash_entries" VALUES(124,14,1,'Number of spans','',6,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','per_min($spans) as spans group by span.status_code','{}');
INSERT INTO "dash_entries" VALUES(125,14,1,'Error rate','',5,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','count($spans{span.status_code=''error''}) / count($spans) as error_rate','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dash_entries" VALUES(126,14,1,'P50 span duration','',4,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p50($spans)','{}');
INSERT INTO "dash_entries" VALUES(127,14,1,'P75 span duration','',3,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p75($spans)','{}');
INSERT INTO "dash_entries" VALUES(128,14,1,'P90 span duration','',2,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p90($spans)','{}');
INSERT INTO "dash_entries" VALUES(129,14,1,'Max span duration','',1,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','max($spans)','{}');
INSERT INTO "dash_entries" VALUES(130,15,1,'Number of spans','',6,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','per_min($spans) as spans group by span.status_code','{}');
INSERT INTO "dash_entries" VALUES(131,15,1,'Error rate','',5,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','count($spans{span.status_code=''error''}) / count($spans) as error_rate','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dash_entries" VALUES(132,15,1,'P50 span duration','',4,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p50($spans)','{}');
INSERT INTO "dash_entries" VALUES(133,15,1,'P75 span duration','',3,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p75($spans)','{}');
INSERT INTO "dash_entries" VALUES(134,15,1,'P90 span duration','',2,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p90($spans)','{}');
INSERT INTO "dash_entries" VALUES(135,15,1,'Max span duration','',1,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','max($spans)','{}');
INSERT INTO "dash_entries" VALUES(136,16,1,'Number of hosts','',6,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','per_min($spans) as spans group by span.status_code','{}');
INSERT INTO "dash_entries" VALUES(137,16,1,'Error rate','',5,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','count($spans{span.status_code=''error''}) / count($spans) as error_rate','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dash_entries" VALUES(138,16,1,'P50 span duration','',4,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p50($spans)','{}');
INSERT INTO "dash_entries" VALUES(139,16,1,'P75 span duration','',3,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p75($spans)','{}');
INSERT INTO "dash_entries" VALUES(140,16,1,'P90 span duration','',2,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p90($spans)','{}');
INSERT INTO "dash_entries" VALUES(141,16,1,'Max span duration','',1,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','max($spans)','{}');
INSERT INTO "dash_entries" VALUES(232,18,4,'Number of hosts','',6,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','per_min($spans) as spans group by span.status_code','{}');
INSERT INTO "dash_entries" VALUES(233,18,4,'Error rate','',5,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','count($spans{span.status_code=''error''}) / count($spans) as error_rate','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dash_entries" VALUES(234,18,4,'P50 span duration','',4,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p50($spans)','{}');
INSERT INTO "dash_entries" VALUES(235,18,4,'P75 span duration','',3,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p75($spans)','{}');
INSERT INTO "dash_entries" VALUES(236,18,4,'P90 span duration','',2,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p90($spans)','{}');
INSERT INTO "dash_entries" VALUES(237,18,4,'Max span duration','',1,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','max($spans)','{}');
INSERT INTO "dash_entries" VALUES(238,19,4,'errors','',0,'stacked-bar','[{"name":"task_already_running","alias":"task_already_running"},{"name":"task_broken","alias":"task_broken"},{"name":"task_missing_dependency","alias":"task_missing_dependency"},{"name":"task_not_found","alias":"task_not_found"},{"name":"task_unknown_error","alias":"task_unknown_error"}]','per_min($task_already_running) | per_min($task_broken) | per_min($task_missing_dependency) | per_min($task_not_found) | per_min($task_unknown_error)','{"per_min(task_already_running)":{"unit":""},"per_min(task_broken)":{"unit":""},"per_min(task_missing_dependency)":{"unit":""},"per_min(task_not_found)":{"unit":""},"per_min(task_unknown_error)":{"unit":""}}');
INSERT INTO "dash_entries" VALUES(239,19,4,'started vs. success','',0,'area','[{"name":"task_success","alias":"task_success"},{"name":"task_started","alias":"task_started"}]','per_min($task_success) | per_min($task_started)','{"per_min(task_started)":{"unit":""},"per_min(task_success)":{"unit":""}}');
INSERT INTO "dash_entries" VALUES(240,5,4,'Number of spans','',6,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','per_min($spans) as spans group by span.status_code','{}');
INSERT INTO "dash_entries" VALUES(241,5,4,'Error rate','',5,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','count($spans{span.status_code=''error''}) / count($spans) as error_rate','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dash_entries" VALUES(242,5,4,'P50 span duration','',4,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p50($spans)','{}');
INSERT INTO "dash_entries" VALUES(243,5,4,'P75 span duration','',3,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p75($spans)','{}');
INSERT INTO "dash_entries" VALUES(244,5,4,'P90 span duration','',2,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p90($spans)','{}');
INSERT INTO "dash_entries" VALUES(245,5,4,'Max span duration','',1,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','max($spans)','{}');
INSERT INTO "dash_entries" VALUES(246,8,4,'Number of spans','',6,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','per_min($spans) as spans group by span.status_code','{}');
INSERT INTO "dash_entries" VALUES(247,8,4,'Error rate','',5,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','count($spans{span.status_code=''error''}) / count($spans) as error_rate','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dash_entries" VALUES(248,8,4,'P50 span duration','',4,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p50($spans)','{}');
INSERT INTO "dash_entries" VALUES(249,8,4,'P75 span duration','',3,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p75($spans)','{}');
INSERT INTO "dash_entries" VALUES(250,8,4,'P90 span duration','',2,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p90($spans)','{}');
INSERT INTO "dash_entries" VALUES(251,8,4,'Max span duration','',1,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','max($spans)','{}');
INSERT INTO "dash_entries" VALUES(252,9,4,'Number of hosts','',6,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','per_min($spans) as spans group by span.status_code','{}');
INSERT INTO "dash_entries" VALUES(253,9,4,'Error rate','',5,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','count($spans{span.status_code=''error''}) / count($spans) as error_rate','{"error_rate":{"unit":"percents"}}');
INSERT INTO "dash_entries" VALUES(254,9,4,'P50 span duration','',4,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p50($spans)','{}');
INSERT INTO "dash_entries" VALUES(255,9,4,'P75 span duration','',3,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p75($spans)','{}');
INSERT INTO "dash_entries" VALUES(256,9,4,'P90 span duration','',2,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','p90($spans)','{}');
INSERT INTO "dash_entries" VALUES(257,9,4,'Max span duration','',1,'line','[{"name":"uptrace.tracing.spans","alias":"spans"}]','max($spans)','{}');
CREATE TABLE "dash_gauges" ("id" INTEGER NOT NULL, "project_id" INTEGER, "dash_id" INTEGER, "dash_kind" VARCHAR, "name" VARCHAR, "description" VARCHAR, "weight" INTEGER, "template" VARCHAR, "metrics" VARCHAR, "query" VARCHAR, "columns" VARCHAR, PRIMARY KEY ("id"), FOREIGN KEY ("dash_id") REFERENCES "dashboards" ("id") ON UPDATE NO ACTION ON DELETE CASCADE);
CREATE TABLE "rule_alerts" ("rule_id" INTEGER NOT NULL, "alerts" json, PRIMARY KEY ("rule_id"));
INSERT INTO "rule_alerts" VALUES(-5211697662468547241,'[{"id":"17264023145074939690","projectId":1,"state":1,"attrs":{"host.name":"HOSTNAME_LEAKED_HERE"},"lastSeenAt":"2023-01-30T14:23:00Z","firedAt":"2023-01-30T14:23:00Z","resolvedAt":"0001-01-01T00:00:00Z","lastSentAt":"0001-01-01T00:00:00Z"}]');
INSERT INTO "rule_alerts" VALUES(5867042355819522643,'[]');
CREATE UNIQUE INDEX metrics_project_id_name_unq
ON metrics (project_id, name);
CREATE UNIQUE INDEX dashboards_project_id_template_id
ON dashboards (project_id, template_id);
COMMIT;