turbot / steampipe

Zero-ETL, infinite possibilities. Live query APIs, code & more with SQL. No DB required.
https://steampipe.io
GNU Affero General Public License v3.0
6.67k stars 262 forks source link

Query time decreasing on subsequent queries with caching disabled #4289

Closed cbruno10 closed 4 weeks ago

cbruno10 commented 1 month ago

Describe the bug When I run the same query multiple times in a single Steampipe session with caching disabled, I'm seeing the query times decrease. For instance, if I run select instance_id, account_id from aws_all.aws_ec2_instance (which has 2 connections) multiple times:

If I just run the query for a single connection, select instance_id, account_id from aws.aws_ec2_instance:

Is it expected that the first query and subsequent queries have a timing difference?

Steampipe version (steampipe -v) Steampipe v0.23.2

To reproduce See queries and configs above

Expected behavior Consistent timing results

Additional context Add any other context about the problem here.

cbruno10 commented 4 weeks ago

Decrease in time is due to plugin caching of creds, closing issue.