## Count a table's rows `GET /v1/subgraphs/{name}/{table}/count` How many rows match the filters. Takes the same column filters and `_search` as the row list. ### Path parameters | Name | Type | Description | | --- | --- | --- | | `name` | string, required | Subgraph name, as deployed (the `name` in its definition). | | `table` | string, required | Table name, one of the keys of the definition's `schema`. `GET /v1/subgraphs/{name}` lists them. | ### Query parameters | Name | Type | Description | | --- | --- | --- | | `_count` | enum | `exact` runs COUNT(*). `estimate` reads the planner's row estimate instead, with no table scan, but only when there are no filters and no `_search`; otherwise it counts exactly. The estimate can be -1 before the table's first ANALYZE. Values: `exact`, `estimate`. | | `_search` | string | Case-insensitive contains match across every column marked `search: true` in the definition, ORed. 400 on a table with no searchable column. | | `filters` | object | Column filters, one query param each, ANDed. Any table column or system column (`_id`, `_block_height`, `_tx_id`, `_created_at`) works. `col=value` is equality; `col.op=value` applies an operator, one of `gte`, `lte`, `gt`, `lt`, `neq`, `like`, `in`, `notIn`. `like` is a case-insensitive contains match. `in` and `notIn` take a comma-separated list. An unknown column is 400 `INVALID_COLUMN`; an unknown operator, or the misplaced form `col=op.value`, is 400 `VALIDATION_ERROR`. Bare `limit`, `offset`, `sort`, `order`, `fields` and `search` are 400: control params take a leading underscore. | ### Returns One `SubgraphRowCount` object. ### Responses - `200` The count - `400` A parameter, filter, cursor or body field was refused; `code` says which - `401` This bind requires the instance token, and it was missing or wrong - `404` No readable subgraph by that name (`SUBGRAPH_NOT_FOUND`), or it has no such table (`TABLE_NOT_FOUND`) - `429` Hosted only: rate limited; retry after `Retry-After` seconds. Self-hosted reads are not rate limited ### Example ```bash curl -G https://api.secondlayer.tools/v1/subgraphs/{name}/{table}/count \ -H "Authorization: Bearer $SECONDLAYER_API_KEY" \ -d filters=[object Object] ``` ```json { "count": 48138 } ```