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 vote357 views1 answer
Hour differeence in mysql
SQL
8 votes357 views3 answers
Connect python to mysql
SQL
0 vote370 views2 answers
Mysql update two tables at once
SQL
3 votes359 views2 answers
How to start mysql in terminal
SQL
1 vote338 views1 answer
Type int in mysql maxlenght
SQL
1 vote389 views1 answer
Tsql replace value in json
SQL
0 vote405 views1 answer
Site:av.ru "files"
SQL
4 votes393 views6 answers
Select sql
SQL
21 votes378 views5 answers
Oracle all tables
SQL
0 vote338 views1 answer
Oracle get running queries
SQL