tvondra/index_analyzer tvondra/index_analyzer

  • This repository has been archived on 03/Nov/2019
  • Stars
    star
    4
  • Rank 3,304,323 (Top 66 %)
  • Language
  • License
    Other
  • Created about 12 years ago
  • Updated about 12 years ago
Twitter logo Share LinkedIn logo Share Facebook logo Share
tvondra/index_analyzer
github

tvondra

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

Analyzes existing indexes in a PostgreSQL database and suggests which of them to drop.

More Repositories

1

sequential-uuids

generator of sequential UUIDs
C
274
star
2

pg_tpch

TPC-H like benchmark for PostgreSQL
PHP
95
star
3

tdigest

PostgreSQL extension for estimating percentiles using t-digest
C
86
star
4

count_distinct

An extension with alternative to COUNT(DISTINCT ...) aggregate in PostgreSQL.
C
76
star
5

gdbpg

GDB command(s) making debugging PostgreSQL somewhat easier
Python
55
star
6

pg_check

a tool to verify integrity of PostgreSQL data files
C
48
star
7

geoip

an extension for GeoIP geolocation
PLpgSQL
47
star
8

quantile

an aggregation function for PostgreSQL
C
41
star
9

ispell_czech

Czech ispell dictionary (UTF-8), suitable for PostgreSQL full-text
OpenEdge ABL
28
star
10

distinct_estimators

distinct counters and aggregate functions for distinct estimation in PostgreSQL
C
18
star
11

ccnumber

experimental PostgreSQL data type with encryption off-loaded to a trusted component
C
17
star
12

explain_training

Training explaining execution plans in PostgreSQL. Currently in Czech only.
PLpgSQL
12
star
13

connection_limits

a PostgreSQL extension that allows you to set quotas on connections (per user, database or IP)
C
12
star
14

shared_ispell

Shared ispell dictionary (stored in shared segment, used by multiple connections)
C
11
star
15

perf_tuning_training

Training explaining basics of PostgreSQL performance tuning. See branches for a version in English
10
star
16

trimmed_aggregates

provides trimmed aggregates for PostgreSQL (average, variance, stddev)
C
8
star
17

query_recorder

an extension for recording all executed queries (so that you may replay them later)
C
8
star
18

pg_uuid

UUID
C
4
star
19

md5hash

A custom data type for storing MD5 hashes (instead of the native TEXT varlena type).
C
4
star
20

pg_twitter

PostgreSQL Twitter example
4
star
21

create-statistics-talk

slides for talk about CREATE STATISTICS
4
star
22

query_histogram

provides a simple query execution time histogram for PostgreSQL
C
4
star
23

pg_vault

experimental extension for key-management of encryption keys used in pgcrypto
C
4
star
24

pg-block-bench-pgbench

Gnuplot
3
star
25

block_benchmark

scripts used to benchmark PostgreSQL with various block sizes (db and fs)
3
star
26

hashset

hashset
C
2
star
27

fdw_figures

graphviz figures illustrating FDW API internals
Graphviz (DOT)
2
star
28

scrub

C
2
star
29

pgxn-tester-server

server part (API + UI) of the PGXN Tester
JavaScript
2
star
30

ddsketch

a PostgreSQL extension implementing a fast and fully-mergeable quantile sketch with relative-error guarantees
PLpgSQL
2
star
31

memory-accounting-benchmarks

Shell
1
star
32

fuzzy_logic

Extension with basic fuzzy logic operators (Gödel, Łukasiewicz and product)
1
star
33

pgcommitfest2

pgcommitfest2 fork
JavaScript
1
star
34

pg-fs-benchmark

Postgres benchmark on different filesystems
Shell
1
star
35

kernel-bench

results of pgbench on different kernel versions
Shell
1
star
36

user_info

Extension for listing various user-related info (granted roles, owned objects, ...)
1
star