Simple histogram for numeric data on PostgreSQL

Question

Other databases have good functions for histogram... For example Hive offers histogram_numeric(numeric_column,b), where b is the "number non-uniformly spaced bins".

Is there a library for PostgreSQL that offers a similar function for numeric columns?

Important: this Wiki function is ugly, is not simple.

Are you looking for width_bucket?

user330315
– user330315

2021-03-23 21:30:29 +00:00
Commented Mar 23, 2021 at 21:30 — user330315
– user330315, Commented Mar 23, 2021 at 21:30

Laurenz Albe · Accepted Answer · 2021-03-23 21:01:18Z

3

PostgreSQL is better! It has the ntile window function:

SELECT n, ntile(3) OVER (ORDER BY n)
FROM generate_series(1, 20) AS n;

 n  | ntile 
----+-------
  1 |     1
  2 |     1
  3 |     1
  4 |     1
  5 |     1
  6 |     1
  7 |     1
  8 |     2
  9 |     2
 10 |     2
 11 |     2
 12 |     2
 13 |     2
 14 |     2
 15 |     3
 16 |     3
 17 |     3
 18 |     3
 19 |     3
 20 |     3
(20 rows)

answered Mar 23, 2021 at 21:01

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Simple histogram for numeric data on PostgreSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related