Skip to content

Instantly share code, notes, and snippets.

View mavillan's full-sized avatar
🐲

Martín Villanueva mavillan

🐲
View GitHub Profile
@Puzer
Puzer / optimize_and_predict_daal4py.py
Created April 23, 2021 20:27
LGBM Inference Optimization
import daal4py as d4p
from lightgbm import LGBMClassifier
model = LGBMClassifier()
model.fit(X_data, y_data)
y_pred_orig = model.predict_proba(x_data_dense)[:,1]
daal_model = d4p.get_gbt_model_from_lightgbm(model.booster_)
predictions_container = d4p.gbt_classification_prediction(nClasses=2, resultsToEvaluate='computeClassProbabilities', fptype='float')
@rgreenjr
rgreenjr / postgres_queries_and_commands.sql
Last active May 28, 2025 00:59
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'