Count

Count the number of values in a field

The following query counts the number of values in a field:

SELECT pdb.agg('{"value_count": {"field": "rating"}}') FROM mock_items
WHERE id @@@ pdb.all();

Expected Response

       agg
-----------------
 {"value": 41.0}
(1 row)

See the Tantivy documentation for all available options.

SQL Count Syntax

SQL’s COUNT syntax is supported in beta. To enable it, first run

SET paradedb.enable_aggregate_custom_scan TO on;

With this feature enabled, the following query is equivalent to the above and is executed in the same way.

SELECT COUNT(rating) FROM mock_items
WHERE id @@@ pdb.all();

To count all rows, including rows with null values, use COUNT(*):

SELECT COUNT(*) FROM mock_items
WHERE id @@@ pdb.all();