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

1 vote314 views1 answer
Oracle character set
SQL
0 vote313 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
32 votes342 views6 answers
How to change column name in sql
SQL
6 votes363 views2 answers
Subtr Oracle ?
SQL
16 votes327 views4 answers
Sort by sql
SQL
0 vote316 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
0 vote312 views1 answer
Create new table pl sql
SQL
2 votes316 views1 answer
Oracle trace session
SQL
0 vote320 views1 answer
Import excel to sql
SQL
17 votes313 views6 answers
Mysql import sql file
SQL