2

I've just switched from pgAdmin III to pgAdmin 4, and while overall it seems a lot slicker in terms of UI and presentation, I'm missing a few things from the previous version. In particular, I would show the execution time and number of rows retrieved at the bottom right on the results for selections. In 4, I see a small green popup that contains that information, but disappears after a few seconds. I've found the setting in File->Preferences->SQL Editor->Display called "Query info notifier timeout" that lets me keep the popup there indefinitely until clicked. I also don't see any kind of ongoing runtime display while a query is running. Is there any way to display any of this information more permanently?

2

It's kind of a shame that there is no good solution to this. I found that adding EXPLAIN ANALYZE to the beginning of my query will display results. Some documentation can be found here.

Example:

EXPLAIN ANALYZE
select * from schema.my_table limit 1000 

Yields:

"Limit  (cost=0.00..168.48 rows=1000 width=2644) (actual time=0.048..5.214 rows=1000 loops=1)"
"Append  (cost=0.00..13935338.46 rows=82710326 width=2644) (actual time=0.045..4.880 rows=1000 loops=1)"
"Seq Scan on event_analysis_vw  (cost=0.00..459263.46 rows=3764446 width=3186) (actual time=0.040..4.579 rows=1000 loops=1)"
"Seq Scan on dva_event_analysis_field  (cost=0.00..6640119.59 rows=43856549 width=2623) (never executed)"
"Filter: (is_deleted IS NULL)"
"Seq Scan on dva_event_analysis_field_archived  (cost=0.00..6046496.61 rows=35089331 width=2612) (never executed)"
"Filter: (is_deleted IS NULL)"
"Total runtime: 5.977 ms"

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.