### For an answer to your direct question:

> How can one see when a query result was last cached in SEDE?

**One can't.** This information is simply not exposed to SEDE.

- Cached plans and queries are cleared out during every refresh operation, so its age will always be 7 days or less (unless that specific step in the process fails).
- If one is trying to _defeat_ the cache (force their query to run again), see https://meta.stackexchange.com/q/325802/165455 

----
### For the reasoning _behind_ your question:

> It's useful to see if SEDE has refreshed.

There are much better and more direct ways to do this. [rene](https://meta.stackexchange.com/users/158100/rene) used to use this query:

- [Status of the SEDE Refresh on Sunday 03:00 UTC](https://data.stackexchange.com/stackoverflow/query/1239509/status-of-the-sede-refresh-on-sunday-0300-utc)

We recently [added some views to Data Explorer](https://meta.stackexchange.com/a/398996/165455) in part to provide a lot more transparency into this process. With those views, a couple of ways you could check on us to be sure we actually performed the most recent weekend's refresh (along with exactly when it happened, how long each database took, and what data was included):

- [Details about each database from the most recent SEDE refresh](https://data.stackexchange.com/stackoverflow/query/1836526/details-about-each-database-from-the-most-recent-sede-refresh)

      SELECT site = CONCAT(site_url,'|',long_name), 
             database_name, 
             initialized, 
             made_available,
             processing_time
        FROM dbo.sede_databases
       ORDER BY processing_time DESC;

On any individual database, you can check to be sure that data from the most recent refresh bumps up against midnight UTC on Sunday (which actually has nothing to do with the new views, and could have been done in the past):

- [The 10 most recent questions on Stack Overflow](https://data.stackexchange.com/stackoverflow/query/1836319/10-most-recent-questions-on-stack-overflow)

      SELECT TOP (10) Id, Title, CreationDate 
        FROM Posts 
       WHERE PostTypeId = 1
       ORDER BY Id DESC;

You could run that on any site, but there are some caveats:

- *Not every site has enough activity that this information will be conclusive. Some sites go days without Posts, so I use our busiest site as the model.*
- *While we've attempted to fix the "jagged edge" problem - where the data included in SEDE depended on when a database was loaded - some straggling information can still get through. For example, if a post created at 11:59 is modified at 00:20, that modification might be captured if the source row is read later than 00:20. But the corresponding `PostHistory` row will not be captured.*