Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Optimize the gcp_logging_log_entry table result or result timing by applying a timestamp filter #507

Closed
ParthaI opened this issue Oct 25, 2023 · 1 comment · Fixed by #508
Assignees
Labels
bug Something isn't working

Comments

@ParthaI
Copy link
Contributor

ParthaI commented Oct 25, 2023

Describe the bug
The timestamp qual is ignored, so it's pulling down all data at once (the docs say it should work)

Steampipe version (steampipe -v)
Example: Steampipe v0.21.1

Plugin version (steampipe plugin list)
Example: v0.45.0

To reproduce
Run the following query:

select log_name, receive_timestamp,timestamp, resource_type from gcp_logging_log_entry where log_name = 'projects/hsrket-aaa/logs/diagnostic-log' and timestamp <= '2023-09-29T10:09:08+05:30';

It should only fetch the results whose log entry timestamp value is less than equal to the provided timestamp instead of fetching all the results and filtering them in the steampipe level.

Expected behavior
The table should take less time if we apply any filter for the timestamp.

Additional context
N/A

Copy link

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

@github-actions github-actions bot added the stale No recent activity has been detected on this issue/PR and it will be closed label Dec 24, 2023
@ParthaI ParthaI removed the stale No recent activity has been detected on this issue/PR and it will be closed label Dec 27, 2023
bigdatasourav pushed a commit that referenced this issue Jan 18, 2024
…er and added the columns json_payload, proto_payload, metadata, resource, operation and tags Closes #507 (#508)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment