How to find the root cause of SELECT queries having long execution times
I am having trouble figuring out why my simple SELECT
query is performing poorly on a relatively small table. The execution time on the full push INSERT
query on the target table is under 10 seconds, while SELECT * FROM target_table
took 7:48 when I ran it this morning.