steampipe-postgres-fdw
steampipe-postgres-fdw copied to clipboard
Published
20 hours ago •
turbot
turbot
Join returns zero rows when a required key column is used on one table
~/src/steampipe-plugin-grafana $ STEAMPIPE_LOG=info steampipe query
Welcome to Steampipe v0.8.0-rc.0
For more information, type .help
> select * from grafana_user
+----+-------------------+--------+--------+--------+--------+----------+-------------+-------------+---------------------+---------------------+---------------------+------------------
| id | email | name | login | theme | org_id | is_admin | is_disabled | is_external | updated_at | created_at | last_seen_at | last_seen_at_age
+----+-------------------+--------+--------+--------+--------+----------+-------------+-------------+---------------------+---------------------+---------------------+------------------
| 1 | admin@localhost | <null> | admin | <null> | 1 | true | false | false | 2021-09-03 22:38:31 | 2021-09-03 22:37:13 | 2021-09-04 01:52:31 | < 1m
| 2 | [email protected] | Nathan | nathan | <null> | 1 | false | false | false | 2021-09-03 22:39:30 | 2021-09-03 22:39:30 | 2021-09-04 00:38:21 | 1h
+----+-------------------+--------+--------+--------+--------+----------+-------------+-------------+---------------------+---------------------+---------------------+------------------
>
> select * from grafana_folder_permission where folder_uid = 'AvAWlQ47z'
+------------+---------+---------+--------+-----------+------------+-----------------+-----------+--------------+
| folder_uid | user_id | team_id | role | is_folder | permission | permission_name | folder_id | dashboard_id |
+------------+---------+---------+--------+-----------+------------+-----------------+-----------+--------------+
| AvAWlQ47z | <null> | <null> | Viewer | true | 1 | View | 2 | <null> |
| AvAWlQ47z | 2 | <null> | <null> | true | 1 | View | 2 | <null> |
| AvAWlQ47z | <null> | <null> | Editor | true | 2 | Edit | 2 | <null> |
| AvAWlQ47z | <null> | 1 | <null> | true | 2 | Edit | 2 | <null> |
+------------+---------+---------+--------+-----------+------------+-----------------+-----------+--------------+
> select * from grafana_folder_permission as fp, grafana_user as u where fp.folder_uid = 'AvAWlQ47z' and fp.user_id = u.id
+------------+---------+---------+------+-----------+------------+-----------------+-----------+--------------+----+-------+------+-------+-------+--------+----------+-------------+----
| folder_uid | user_id | team_id | role | is_folder | permission | permission_name | folder_id | dashboard_id | id | email | name | login | theme | org_id | is_admin | is_disabled | is_
+------------+---------+---------+------+-----------+------------+-----------------+-----------+--------------+----+-------+------+-------+-------+--------+----------+-------------+----
+------------+---------+---------+------+-----------+------------+-----------------+-----------+--------------+----+-------+------+-------+-------+--------+----------+-------------+----
>
>
~/src/steampipe-plugin-grafana $
I'm expecting one row to be returned by the join.
Here is the INFO level logging:
2021/09/03 21:53:16 [INFO]
******************************************************
steampipe postgres fdw init
******************************************************
2021/09/03 21:53:16 [INFO] Log level info
2021-09-03T21:53:16.243-0400 [INFO] hub: query cache created
2021-09-03T21:53:16.266-0400 [INFO] hub: goFdwBeginForeignScan, connection 'grafana', table 'grafana_user'
2021-09-03T21:53:16.266-0400 [INFO] hub: executing query for connection grafana, caching ENABLED with TTL 300 seconds
2021-09-03T21:53:16.266-0400 [INFO] hub: --------
2021-09-03T21:53:16.266-0400 [INFO] hub: no quals
2021-09-03T21:53:16.266-0400 [INFO] hub: --------
2021-09-03T21:53:16.266-0400 [INFO] hub: CACHE MISS - no index
2021-09-03T21:53:16.266-0400 [INFO] hub: StartScan
table: grafana_user
2021-09-03T21:53:16.332-0400 [INFO] plugin.steampipe-plugin-grafana.plugin: [INFO] ------------------------------------
2021-09-03T21:53:16.332-0400 [INFO] plugin.steampipe-plugin-grafana.plugin: [INFO] Concurrency Summary
2021-09-03T21:53:16.332-0400 [INFO] plugin.steampipe-plugin-grafana.plugin: [INFO] ------------------------------------
2021-09-03T21:53:16.332-0400 [INFO] plugin.steampipe-plugin-grafana.plugin: [INFO] getUser : 2
2021-09-03T21:53:16.332-0400 [INFO] plugin.steampipe-plugin-grafana.plugin: [INFO] ------------------------------------
2021-09-03T21:53:16.332-0400 [INFO] plugin.steampipe-plugin-grafana.plugin: [INFO] Total : 2
2021-09-03T21:53:16.332-0400 [INFO] plugin.steampipe-plugin-grafana.plugin: [INFO] ------------------------------------
2021-09-03T21:53:16.333-0400 [INFO] hub: adding 2 rows to cache
2021-09-04 01:53:16.333 GMT [57147] LOG: statement: COMMIT
2021-09-04 01:53:43.443 GMT [57147] LOG: statement: BEGIN READ WRITE
2021-09-04 01:53:43.443 GMT [57147] LOG: statement: select * from grafana_folder_permission where folder_uid = 'AvAWlQ47z'
2021-09-03T21:53:43.444-0400 [INFO] hub: goFdwBeginForeignScan, connection 'grafana', table 'grafana_folder_permission'
2021-09-03T21:53:43.444-0400 [INFO] hub: executing query for connection grafana, caching ENABLED with TTL 300 seconds
2021-09-03T21:53:43.444-0400 [INFO] hub: connection 'grafana', table 'grafana_folder_permission', quals
----------------------------------------------------------------
Column: folder_uid, Operator: '=', Value: 'AvAWlQ47z'
----------------------------------------------------------------
2021-09-03T21:53:43.444-0400 [INFO] hub: CACHE MISS - no index
2021-09-03T21:53:43.444-0400 [INFO] hub: StartScan
table: grafana_folder_permission
2021-09-03T21:53:43.464-0400 [INFO] hub: adding 4 rows to cache
2021-09-04 01:53:43.465 GMT [57147] LOG: statement: COMMIT
2021-09-04 01:54:38.984 GMT [57147] LOG: statement: BEGIN READ WRITE
2021-09-04 01:54:38.985 GMT [57147] LOG: statement: select * from grafana_folder_permission as fp, grafana_user as u where fp.folder_uid = 'AvAWlQ47z' and fp.user_id = u.id
2021-09-03T21:54:38.985-0400 [INFO] hub: goFdwBeginForeignScan, connection 'grafana', table 'grafana_user'
2021-09-03T21:54:38.985-0400 [INFO] hub: executing query for connection grafana, caching ENABLED with TTL 300 seconds
2021-09-03T21:54:38.985-0400 [INFO] hub: --------
2021-09-03T21:54:38.985-0400 [INFO] hub: no quals
2021-09-03T21:54:38.985-0400 [INFO] hub: --------
2021-09-03T21:54:38.986-0400 [INFO] hub: CACHE HIT
2021-09-03T21:54:38.986-0400 [INFO] hub: goFdwBeginForeignScan, connection 'grafana', table 'grafana_folder_permission'
2021-09-03T21:54:38.986-0400 [INFO] hub: executing query for connection grafana, caching ENABLED with TTL 300 seconds
2021-09-03T21:54:38.986-0400 [INFO] hub: connection 'grafana', table 'grafana_folder_permission', quals
----------------------------------------------------------------
Column: folder_uid, Operator: '=', Value: 'AvAWlQ47z'
Column: folder_uid, Operator: '=', Value: 'AvAWlQ47z'
Column: user_id, Operator: '=', Value: '0'
----------------------------------------------------------------
2021-09-03T21:54:38.986-0400 [INFO] hub: CACHE MISS - no index
2021-09-03T21:54:38.986-0400 [INFO] hub: StartScan
table: grafana_folder_permission
2021-09-03T21:54:38.986-0400 [INFO] hub: goFdwBeginForeignScan, connection 'grafana', table 'grafana_folder_permission'
2021-09-03T21:54:38.986-0400 [INFO] hub: executing query for connection grafana, caching ENABLED with TTL 300 seconds
2021-09-03T21:54:38.986-0400 [INFO] hub: connection 'grafana', table 'grafana_folder_permission', quals
----------------------------------------------------------------
Column: folder_uid, Operator: '=', Value: 'AvAWlQ47z'
Column: folder_uid, Operator: '=', Value: 'AvAWlQ47z'
Column: user_id, Operator: '=', Value: '1'
----------------------------------------------------------------
2021-09-03T21:54:38.986-0400 [INFO] hub: CACHE MISS - no index
2021-09-03T21:54:38.986-0400 [INFO] hub: StartScan
table: grafana_folder_permission
2021-09-03T21:54:39.022-0400 [INFO] hub: goFdwBeginForeignScan, connection 'grafana', table 'grafana_folder_permission'
2021-09-03T21:54:39.022-0400 [INFO] hub: executing query for connection grafana, caching ENABLED with TTL 300 seconds
2021-09-03T21:54:39.022-0400 [INFO] hub: connection 'grafana', table 'grafana_folder_permission', quals
----------------------------------------------------------------
Column: user_id, Operator: '=', Value: '2'
Column: folder_uid, Operator: '=', Value: 'AvAWlQ47z'
Column: folder_uid, Operator: '=', Value: 'AvAWlQ47z'
----------------------------------------------------------------
2021-09-03T21:54:39.022-0400 [INFO] hub: CACHE HIT
2021-09-04 01:54:39.023 GMT [57147] LOG: statement: COMMIT
2021-09-03T21:54:44.620-0400 [INFO] hub: 2 CACHE HITS
2021-09-03T21:54:44.620-0400 [INFO] hub: 4 CACHE MISSES
2021-09-04 01:54:44.708 GMT [57186] LOG: statement: ;
2021-09-04 01:54:44.708 GMT [57186] LOG: statement: select count(*) from pg_stat_activity where client_port IS NOT NULL and application_name='steampipe' and backend_type='client backend';
2021-09-04 01:54:44.750 GMT [57115] LOG: received smart shutdown request
2021-09-04 01:54:44.752 GMT [57115] LOG: background worker "logical replication launcher" (PID 57126) exited with exit code 1
2021-09-04 01:54:44.752 GMT [57122] LOG: shutting down
2021-09-04 01:54:44.757 GMT [57115] LOG: database system is shut down
