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

1 vote192 views1 answer
Sql get missing id
SQL
0 vote303 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
6 votes187 views3 answers
Mysql first day of year
SQL
2 votes205 views1 answer
Orcale index size
SQL
0 vote216 views1 answer
Psotgres multiple values
SQL
0 vote217 views2 answers
While mysql
SQL
1 vote203 views1 answer
Delete specific row in sql
SQL
2 votes195 views1 answer
Set column to not null mysql
SQL
1 vote201 views1 answer
Install postgresql on raspberry pi
SQL
1 vote157 views1 answer
Postgres division by zero
SQL