Skip to content

Instantly share code, notes, and snippets.

View romikoops's full-sized avatar

Roman Parashchenko romikoops

View GitHub Profile
This file has been truncated, but you can view the full file.
@romikoops
romikoops / helm-cheatsheet.md
Created September 5, 2019 23:19 — forked from tuannvm/argo.md
#Helm #Kubernetes #cheatsheet, happy helming!
---
apiVersion: rbac.authorization.k8s.io/v1
kind: ClusterRole
metadata:
name: system:aggregated-metrics-reader
labels:
rbac.authorization.k8s.io/aggregate-to-view: "true"
rbac.authorization.k8s.io/aggregate-to-edit: "true"
rbac.authorization.k8s.io/aggregate-to-admin: "true"
rules:
@romikoops
romikoops / query_planner.markdown
Created June 3, 2021 17:34 — forked from hgmnz/query_planner.markdown
PostgreSQL query plan and SQL performance notes

Types of index scans

Indexes

Sequential Scan:

  • Read every row in the table
  • No reading of index. Reading from indexes is also expensive.
SELECT
t0. "id",
t0. "inserted_at"::timestamp AT TIME ZONE 'Etc/UTC' AT TIME ZONE 'Europe/Amsterdam',
o1. "inserted_at"::timestamp AT TIME ZONE 'Etc/UTC' AT TIME ZONE 'Europe/Amsterdam',
o1. "id",
o3. "id" AS "client_order_id",
o4. "id" AS "hedge_order_id",
o1. "source",
c2. "slug",
t0. "position",