Actually I found the SQL query and run directly.
Here are the results:
in Tableau run 30min
run directly through pgAdmin: 0.45 sec
this does seem peculiar. But are you using custom SQL? If so, Tableau will wrap the SQL inside of its own SQL and I forget if the predicates live on the inner or the outer SQL.
Also, you may be able to look in the Tableau logs under "My Tableau Repository" to see what is going on.
I simply drag and drop one measure and one dimension.
The query is very simple:
"SELECT ""heartbeats_aggregated_fact_transformed_15"".""device_type"" AS ""device_type"",
SUM(""heartbeats_aggregated_fact_transformed_15"".""time_in_player"") AS ""sum:time_in_player:ok""
FROM ""public"".""heartbeats_aggregated_fact_transformed_15"" ""heartbeats_aggregated_fact_transformed_15""
GROUP BY 1"
ok, it's not that then.
I see you're running within Postgres. Does your instance have the concept of resource queues that may be causing a queue of the query? And are you running with the same db driver and userid?
Yes, it's Postgres and I'm not familiar with resource queues, so I need to research it, but I doubt very much.
And yes, I run with the same user.
I just add additional column to the canvas and Tableau run for over 30 min.
When I copy that query and run from pgAdmin it run under 1 sec:
SELECT heartbeats_aggregated_fact_transformed_15.createddate_month AS createddate_month,
heartbeats_aggregated_fact_transformed_15.device_type AS device_type,
SUM(heartbeats_aggregated_fact_transformed_15.time_in_player) AS "time_in_player'
FROM public.heartbeats_aggregated_fact_transformed_15 heartbeats_aggregated_fact_transformed_15
GROUP BY 1,
ok. Resource queues may only apply to Greenplum which is a derivative to the base Postgres. And it's been something that we've had to deal with here.
Is the result set large? By chance, maybe your network is taking a while to transmit the dataset back from your db to Tableau?
There is only 25 records returned.
BTW Just thought about the driver - I don't know if the driver is the same since I don't know what driver is Tableau using (probably come with the installation - I used all default installations).
I just downloaded Tableau today - the desktop, trial version. I understand it comes with Postgres driver.
I'm using Postgres 9.2.2
All my queries are running in thousands of seconds (tens of MINUTES) in Tableau and in milliseconds directly.
Can anybody advise? I'm completely blocked
Do you have the option of opening a support case with Tableau? Or ask your account rep? If so, this may be more expedient. The cause could be anything. Some additional items that come to mind is driver compatibility, firewall blocking issues, hard drive disk space, RAM availability.
I'm using a trial version, so I don't expect any support.
And as fare as the issues you mentioned, none of them seems to be an issue.
I'm completely lost
I will try to continue to help, but you should know that this community forum is all volunteer based and best effort based on time in between my own work.
If you want, do this
1. Close Tableau Desktop
2. In order to have clean logs, clear out any files within folder C:\Users\yourusername\Documents\My Tableau Repository\Logs
3. Open Tableau Desktop and reproduce the issue
4. Send me the log file(s). email@example.com
5. I will have a look to see if I see anything "weird" that may point at root cause
Thanks so much Jeff,
I do understand it is a volunteer's forum and I very much appreciate your help.
I'm attaching the zip file with all logs and some print screens as well as copy of performance trace workbook.
If you could figure out what happening there, it would mean a lot to my project.
Tableau Logs.zip 312.6 KB