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

14 votes242 views4 answers
Sql compiler
SQL
4 votes220 views1 answer
Oracle session date format
SQL
54 votes346 views6 answers
Sql rename column
SQL
0 vote235 views1 answer
Get clob size oracle
SQL
0 vote203 views1 answer
Full syntax inner join
SQL
1 vote228 views1 answer
Create another table from existing table sql oracle
SQL
11 votes224 views1 answer
Sql query to find duplicates in column
SQL
0 vote200 views1 answer
Ms sql unique
SQL
1 vote237 views1 answer
Mysql alter decimal precision
SQL
0 vote226 views1 answer
Power bi find all ids not in other tables
SQL