Skip to content

Instantly share code, notes, and snippets.

View splhack's full-sized avatar

Kazuki Sakamoto splhack

297 followers · 2 following
View GitHub Profile
@splhack
splhack / gist:b4cf053a225e22ad432e6ef35ffc345c
Created February 4, 2022 06:34
[ 99%] Linking CXX executable zig0
g++ -O3 -g -pipe -Wall -Wno-error -Wp,-D_FORTIFY_SOURCE=2 -fstack-protector --param=ssp-buffer-size=4 -fno-omit-frame-pointer -momit-leaf-frame-pointer -fno-reorder-blocks-and-partition -gz=none -Wl,-z,relro -fcommon -march=corei7 -mtune=skylake -nostdinc -grecord-gcc-switches -fdebug-prefix-map=zig_root=zig_root -fdebug-prefix-map=build=zig_root -O3 -DNDEBUG <libpaths...> -rdynamic CMakeFiles/zig0.dir/src/stage1/zig0.cpp.o -o zig0 zigcpp/libzigstage1.a zigcpp/libopt_c_util.a zigcpp/libembedded_softfloat.a zigcpp/libzigcpp.a -Wl,-Bstatic -lclangFrontendTool -lclangCodeGen -lclangFrontend -lclangDriver -lclangSerialization -lclangSema -lclangStaticAnalyzerFrontend -lclangStaticAnalyzerCheckers -lclangStaticAnalyzerCore -lclangAnalysis -lclangASTMatchers -lclangAST -lclangParse -lclangSema -lclangStaticAnalyzerFrontend -lclangStaticAnalyzerCheckers -lclangStaticAnalyzerCore -lclangAnalysis -lclangASTMatchers -lclangAST -lclangParse -lclangBasic -lclangEdit -lclangLex -lclangA
@splhack
splhack / opencue_find_jobs_by_show_optimized.analyze.txt
Created November 30, 2021 04:30
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Limit (cost=2208.55..2463.59 rows=1 width=57) (actual time=22.030..36.003 rows=500 loops=1)
-> Nested Loop Semi Join (cost=2208.55..2463.59 rows=1 width=57) (actual time=22.028..35.937 rows=500 loops=1)
Join Filter: ((layer.pk_layer)::text = (l.pk_laye
@splhack
splhack / opencue_find_jobs_by_show_original.analyze.txt
Created November 30, 2021 04:29
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Subquery Scan on t1 (cost=1054.66..1054.69 rows=1 width=57) (actual time=245.933..249.048 rows=500 loops=1)
Filter: (t1.rank <= 500)
Rows Removed by Filter: 6835
-> WindowAgg (cost=1054.66..1054.68 rows=1 width=57) (actual time=245.932..248.679 rows=7335 loops=1)
-> Sort (c
@splhack
splhack / opencue_find_jobs_by_show_optimized.sql
Created November 30, 2021 04:28
/*EXPLAIN ANALYZE*/
WITH sorted_job AS (
SELECT
ROW_NUMBER() OVER (ORDER BY job_resource.int_priority DESC, job.ts_started ASC) AS rank,
job.pk_job ,
job.pk_folder ,
job.ts_started ,
job_resource.int_priority ,
job_resource.int_cores ,
job_resource.int_max_cores,
@splhack
splhack / opencue_find_jobs_by_show_original.sql
Created November 30, 2021 04:27
/*EXPLAIN ANALYZE*/
SELECT rank, pk_job, int_priority, ts_started FROM (
SELECT
ROW_NUMBER() OVER (ORDER BY job_resource.int_priority DESC, job.ts_started ASC) AS rank,
job.pk_job,
job_resource.int_priority,
job.ts_started
FROM
job ,
job_resource ,
@splhack
splhack / remote_desktop_change_command_to_control_and_option_to_command.json
Created June 26, 2021 21:33
{
"title": "Remote Desktop",
"rules": [
{
"description": "Change command to control and option to command",
"manipulators": [
{
"type": "basic",
"from": {
"key_code": "left_option",
@splhack
splhack / cjsl-1.12.dtd.diff
Last active March 25, 2021 06:24
--- ./src/main/resources/public/dtd/cjsl-1.11.dtd 2021-02-19 09:34:45.000000000 -0800
+++ ./src/main/resources/public/dtd/cjsl-1.12.dtd 2021-03-24 23:24:22.000000000 -0700
@@ -1,5 +1,5 @@
<!-- ================================================================= -->
-<!-- SpiCue Job Spec DTD ver 1.11 -->
+<!-- SpiCue Job Spec DTD ver 1.12 -->
<!-- [email protected] -->
<!-- ================================================================= -->
@@ -38,7 +38,7 @@
@splhack
splhack / V1__Initial_schema.sql.diff
Created February 19, 2021 09:35
diff --git a/cuebot/src/main/resources/conf/ddl/postgres/migrations/V1__Initial_schema.sql b/cuebot/src/main/resources/conf/ddl/postgres/migrations/V1__Initial_schema.sql
index c9d7714..ce78238 100644
--- a/cuebot/src/main/resources/conf/ddl/postgres/migrations/V1__Initial_schema.sql
+++ b/cuebot/src/main/resources/conf/ddl/postgres/migrations/V1__Initial_schema.sql
@@ -10,18 +10,19 @@ CREATE TABLE history_period_bak (
CREATE TABLE frame_history (
pk_frame_history VARCHAR(36) DEFAULT uuid_generate_v1() NOT NULL,
pk_frame VARCHAR(36) NOT NULL,
pk_layer VARCHAR(36) NOT NULL,
pk_job VARCHAR(36) NOT NULL,
@splhack
splhack / V1__Initial_schema.sql
Created February 19, 2021 09:22
CREATE VIEW vs_show_resource (pk_show, int_cores) AS
SELECT
job.pk_show,
SUM(int_cores) AS int_cores
FROM
job,
job_resource
WHERE
job.pk_job = job_resource.pk_job
@splhack
splhack / V10__Support_multiple_GPU.sql.diff
Last active February 20, 2021 05:54
--- V1__Initial_schema.sql.txt 2021-02-19 19:40:43.000000000 -0800
+++ V10__Support_multiple_GPU.sql 2021-02-19 21:53:11.000000000 -0800
+DROP VIEW vs_show_resource;
+CREATE VIEW vs_show_resource (pk_show, int_cores, int_gpus) AS
SELECT
job.pk_show,
- SUM(int_cores) AS int_cores
+ SUM(int_cores) AS int_cores, SUM(int_gpus) AS int_gpus
FROM
job,