A script to benchmark execution time and accuracy of postgres stats generation, in particular for row count estimations.
This is the query used to populate the table (with different sizes):
INSERT INTO test_row_estimation
SELECT my_id, ST_SetSRID(ST_MakePoint(0,0),4326), my_id, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit'
FROM generate_series(1, 1000) AS my_id;