sudo apt install zsh-autosuggestions zsh-syntax-highlighting zsh
| package main | |
| import ( | |
| "fmt" | |
| ) | |
| type Number interface { | |
| ~int | ~int8 | ~int16 | ~int32 | ~int64 | |
| } |
| import time | |
| import signal | |
| def busy_work(seconds): | |
| print("Start busy_work") | |
| time.sleep(seconds) | |
| print("Stop busy_work") | |
| CREATE TABLE large_test (num1 bigint, num2 double precision, num3 double precision); | |
| INSERT INTO large_test (num1, num2, num3) | |
| SELECT round(random()*10), random(), random()*142 | |
| FROM generate_series(1, 20000000) s(i); | |
| EXPLAIN (analyse, buffers) | |
| SELECT num1, avg(num3) as num3_avg, sum(num2) as num2_sum | |
| FROM large_test | |
| GROUP BY num1; |