Measure Execution Time with postgresql_query and postgresql_script

[optica-phoffmann]

SUMMARY

I want to be able to get the execution time of an sql query. I searched the docs of postgresql_query and postgresql_script. I looks like this feature is currently not available. I searched the issues in this repo but couldn't find any discussion about this.

ISSUE TYPE

• Feature Idea

COMPONENT NAME

• postgresql_query
• postgresql_script

ADDITIONAL INFORMATION

Ansible Task Example:

- name: Simple select query to acme db
  community.postgresql.postgresql_query:
    db: acme
    query: SELECT id FROM accounts
    measure_time: yes

Additional Return value

execution_time_ms: 7104.652

[hunleyd]

Thanks for the feature suggestion @optica-phoffmann ! Is this something you would want to tackle?

[Andersson007]

looking

[Andersson007]

@optica-phoffmann would something like #792 work for you?

[optica-phoffmann]

@Andersson007 Wow, looks very nice to me. Thank you!

[Andersson007]

@optica-phoffmann thanks for the contribution by requesting the feature! @hunleyd thanks for the contribution by reviewing and merging the PR!
I think we could do the same for community.mysql and community.clickhouse collections as there are similar modules.