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 vote104 views2 answers
Drop check constraint in ms sql
SQL
0 vote102 views1 answer
SQL loop with cursor
SQL
2 votes110 views1 answer
How to check if a row is null in sql
SQL
9 votes109 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote121 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote115 views1 answer
Laravel eloquent get generated sql
SQL
1 vote105 views1 answer
How to find median of a column sql
SQL
1 vote76 views3 answers
Grant syntax in sql
SQL
0 vote102 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
0 vote132 views1 answer
Mysql last friday of current month
SQL