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

6 votes301 views2 answers
Non relational database
SQL
0 vote293 views1 answer
Sql check for null and empty string
SQL
2 votes240 views2 answers
Mysql get last character of string
SQL
1 vote322 views2 answers
Full join
SQL
0 vote284 views1 answer
Mysql count with two joins
SQL
1 vote326 views1 answer
Concat first name and last name in mysql
SQL
0 vote267 views1 answer
How many columns can be used for creating index?
SQL
0 vote275 views1 answer
Use between operator in mysql
SQL
0 vote281 views1 answer
Grepper sql workbench download
SQL
0 vote241 views1 answer
How to check oracle index table
SQL