Postgresql SELECT optimisation into Django ORM
Please see below a PostgreSQL SELECT statement. This presently returns around 300k rows, which is the grouped result of several million underlying rows. The dataset is only going to get larger. Using the ANALYSE EXPLAIN function the cost of this select is 111847 units.
Postgresql SELECT optimisation into Django ORM
Please see below a PostgreSQL SELECT statement. This presently returns around 300k rows, which is the grouped result of several million underlying rows. The dataset is only going to get larger. Using the ANALYSE EXPLAIN function the cost of this select is 111847 units.