Is the following the most concise way of obtaining a count of all rows?

const { count } = await supabase.from('some_table').select('*', {count: 'exact', head: true})

Hello @VΞLO! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

Without looking into what PostgREST does, I'd say picking a single column instead of * MIGHT be better. It could make no difference depending on the rest of the flow at the server.

VΞLO (2022-04-20)

thanks, did not think of that!

Well it would use that anyway to do the count, just saying one column because I'm not sure how far "head" is propagated to not return data. If it is just at the http interface then you might get a small benefit on the actual database side, but even that may not be true based on how the database reads the table into memory. Basically it can't hurt though.