Postgresql datetrunc too slow

CREATE INDEX ON test (date_trunc('day', updated_at));

/*If updated_at is a timestamp without time zone, that will work fine. 
For a timestamp with time zone, you'll have to specify a time zone, 
because otherwise the result will depend on the session time zone, 
which makes it unusable for an index:*/

CREATE INDEX ON test (date_trunc('day', updated_at AT TIME ZONE 'UTC'));

Source: stackoverflow.com

Similar codes

0 vote136 views0 answer
SQL
0 vote181 views1 answer
Postgresql cast as year and month from timestamp
SQL
0 vote153 views2 answers
Create new table plsql
SQL
0 vote129 views1 answer
Sql table to store status
SQL
2 votes149 views1 answer
Install sqlite npm
SQL
0 vote161 views1 answer
Mariadb alter table add column if not exists example
SQL
0 vote156 views1 answer
Power bi find all ids not in other tables
SQL
0 vote168 views1 answer
Duplix print in Smartforms
SQL
1 vote118 views1 answer
Into sql
SQL
0 vote186 views10 answers
John the ripper mysql
SQL