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 vote116 views1 answer
See Foreign Key
SQL
0 vote123 views1 answer
Mysql utc timestamp
SQL
0 vote116 views2 answers
Sqlite
SQL
-1 vote114 views3 answers
Check table exist postgresql
SQL
14 votes123 views3 answers
Alter foreign key
SQL
16 votes140 views3 answers
T-SQL Add Column
SQL
2 votes119 views1 answer
Find all triggers in database
SQL
2 votes110 views2 answers
Join update query in sql
SQL
0 vote116 views1 answer
Sql with example
SQL
0 vote118 views1 answer
A network or instance-specific error sql server
SQL