Sfrgttk

What's the output of a record cartridge playing an out-of-speed record

Why not use SQL instead of GraphQL?

Writing rule stating superpower from different root cause is bad writing

Why can't I see bouncing of a switch on an oscilloscope?

How to write a macro that is braces sensitive?

Are the number of citations and number of published articles the most important criteria for a tenure promotion?

I’m planning on buying a laser printer but concerned about the life cycle of toner in the machine

Why did Neo believe he could trust the machine when he asked for peace?

What is the offset in a seaplane's hull?

Why don't electron-positron collisions release infinite energy?

What are these boxed doors outside store fronts in New York?

Why do I get two different answers for this counting problem?

Why "Having chlorophyll without photosynthesis is actually very dangerous" and "like living with a bomb"?

Has the BBC provided arguments for saying Brexit being cancelled is unlikely?

How to format long polynomial?

Do VLANs within a subnet need to have their own subnet for router on a stick?

How could an uplifted falcon's brain work?

What's the point of deactivating Num Lock on login screens?

What do the dots in this tr command do: tr .............A-Z A-ZA-Z <<< "JVPQBOV" (with 13 dots)

What does it mean : "Canonical representative of Sbox is 0123468A5BCF79DE"? and How can we calculate this representative for Sbox?

How is it possible to have an ability score that is less than 3?

Why, historically, did Gödel think CH was false?

Arthur Somervell: 1000 Exercises - Meaning of this notation

Modeling an IPv4 Address

How to optimize time based data?

Optimizing for data that does not fit in memoryWhy does SemiJoin node receive so bad statistic even after runnning ANALYZEEliminate duplicates and optimize performance for big count and small LIMITPostgres 9.1 query fast second timeOptimize query with multiple IN statementsEfficiently store time based dataHow to optimize min/max queries for large tables on PostgreSQLUnderstanding query variance in exec time in PostgreSQL?Varying query runtime in tag based reporting and aggregation systemImprove Performance on GROUP BY - large table PostgreSQL

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

I need help optimizing time-based queries on a relatively small table.

The table looks like this:

time int | tag varchar(21) | val decimal

I also have a index like such

create index _index on table (time, tag)

And queries looks like this:

select * from table where time >= 1554599241 and time <= 1554599251 and tag = ANY('{aaa,bbb,ccc}')

Is there any way for me to reduce query times?

postgresql

share

asked 9 mins ago

dotconnordotconnor

1011

New contributor

dotconnor is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I need help optimizing time-based queries on a relatively small table.

The table looks like this:

time int | tag varchar(21) | val decimal

I also have a index like such

create index _index on table (time, tag)

And queries looks like this:

select * from table where time >= 1554599241 and time <= 1554599251 and tag = ANY('{aaa,bbb,ccc}')

Is there any way for me to reduce query times?

postgresql

share

asked 9 mins ago

dotconnordotconnor

1011

New contributor

dotconnor is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I need help optimizing time-based queries on a relatively small table.

The table looks like this:

time int | tag varchar(21) | val decimal

I also have a index like such

create index _index on table (time, tag)

And queries looks like this:

select * from table where time >= 1554599241 and time <= 1554599251 and tag = ANY('{aaa,bbb,ccc}')

Is there any way for me to reduce query times?

postgresql

share

asked 9 mins ago

dotconnordotconnor

1011

New contributor

dotconnor is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

time int | tag varchar(21) | val decimal

create index _index on table (time, tag)

select * from table where time >= 1554599241 and time <= 1554599251 and tag = ANY('{aaa,bbb,ccc}')

share

asked 9 mins ago

dotconnordotconnor

1011

New contributor

dotconnor is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 9 mins ago

dotconnordotconnor

1011

New contributor

dotconnor is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 9 mins ago

dotconnordotconnor

1011

New contributor

dotconnor is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 9 mins ago

dotconnordotconnor

1011