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 vote154 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
1 vote156 views1 answer
Postgresql update auto_increment value
SQL
0 vote174 views8 answers
Sql to c# linq converter online
SQL
0 vote145 views1 answer
How to check common records in 2 table
SQL
0 vote166 views2 answers
Suse Linux restart MySQL
SQL
0 vote127 views2 answers
Insert into
SQL
0 vote129 views3 answers
Average salary in sql
SQL
0 vote147 views1 answer
Sql cnvert bit to nvarchar
SQL
2 votes134 views2 answers
How to view created temporary tables in mysql
SQL
0 vote124 views1 answer
Using GROUP BY in MySQL Join Table
SQL