Skip to main content

Count rows

It is very easy to count the number of records in a table or as a result of a query.

Count rows without filter​


curl --request GET \
--url http://localhost:8080/v1/rdbms/pgdb/actor/count \
--header 'User-Agent: insomnia/8.6.1'


HTTP Response​

{
	"count": 12
}

tip

This query can be very slow if there are many rows in the table.

Count rows with filter​


curl --request GET \
--url 'http://localhost:8080/v1/rdbms/pgdb/actor/count?filter=last_name==Khan' \
--header 'User-Agent: insomnia/8.6.1'


HTTP Response​

{
	"count": 5
}