Libreria di snippet

Snippet pronti e testati per Python, Flask, JavaScript, SQL, HTML, CSS e Bash. Aprili nel playground.

Mostra solo gli snippet salvati in questo browser

2 snippet

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

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

Servizi

Catalogo app

Impara

Azienda

Aiuto

Cambia lingua

Libreria di snippet

Upsert: insert or update

Find slow queries