Biblioteca de snippets

Snippets testados e prontos para copiar em Python, Flask, JavaScript, SQL, HTML, CSS e Bash. Abra qualquer um no playground.

Mostrar só os snippets salvos neste navegador

3 snippets

sql

Upsert: insert or update

Insert a row, or update it when the unique key already exists.

INSERT INTO page_views (path, day, views)
VALUES ('/pricing', CURRENT_DATE, 1)
ON CONFLICT (path, day)
DO UPDATE SET views = page_views.views + EXCLUDED.views;

intermediate #postgres#upsert#writes

bash

Back up a PostgreSQL database

Dump, compress, and keep only the last 14 backups.

#!/usr/bin/env bash
set -Eeuo pipefail
: "${DATABASE_URL:?set DATABASE_URL}"

dir="/var/backups/app"

intermediate #postgres#backups#cron

sql

Find slow queries

The queries using the most total time (needs the pg_stat_statements extension).

CREATE EXTENSION IF NOT EXISTS pg_stat_statements;

SELECT round(total_exec_time::numeric, 1) AS total_ms,
       calls,
       round(mean_exec_time::numeric, 2) AS mean_ms,

advanced #postgres#performance#monitoring

PandaDev

Serviços

Catálogo de apps

Aprender

Empresa

Ajuda

Mudar idioma

Biblioteca de snippets

Upsert: insert or update

Back up a PostgreSQL database

Find slow queries