psql でクエリした結果を CSV 出力する（空白を含めずに）には、-A オプションをつける。
-A
--no-align
Switches to unaligned output mode. (The default output mode is aligned.) This is equivalent to \pset format unaligned.
実行例
- 実行コマンド
$ CURRENT_DATE=`date '+%Y%m%d-%H%M%S'` $ psql -aA "host=rs-ra3-4xl-4n.********.us-east-1.redshift.amazonaws.com user=awsuser dbname=tpch_3tb port=5439" -f svl_query_metrics_summary.sql -o svl_query_metrics_summary_${CURRENT_DATE}.csv
- svl_query_metrics_summary.sql
select * from svl_query_metrics_summary order by query_execution_time desc;
実行結果
$ cat svl_query_metrics_summary_20241218-081242.csv userid|query|service_class|query_cpu_time|query_blocks_read|query_execution_time|query_cpu_usage_percent|query_temp_blocks_to_disk|segment_execution_time|cpu_skew|io_skew|scan_row_count|join_row_count|nested_loop_join_row_count|return_row_count|spectrum_scan_row_count|spectrum_scan_size_mb|query_queue_time|service_class_name 100|612499|6|2334|349436|263|51.01||139|4.23|1.14|17880867776|971957624||||||Default queue 100|613093|6|2796|348753|205|52.15||79|4.10|2.38|17839691328|972763752||||||Default queue 100|612903|6|2019|223517|172|73.17|122165|143|16.00|1.55|18000048306|178783||||||Default queue 100|612572|6|2027|225690|166|75.62|99150|124|8.00|1.81|18000048306|1309830||||||Default queue 100|613018|6|2245|126770|142|34.93||140|1.25|1.20|4480201373|4572500800||||||Default queue 100|612745|6|1606|195143|122|44.09||116|1.36|1.01|17634585440|||||||Default queue 100|612659|6|2131|127179|118|40.10||112|1.60|1.20|4478152101|4537255472||||||Default queue 100|612628|6|1377|248820|113|56.97||52|1.39|1.33|17826007552|876903909||||||Default queue 100|613140|6|1603|196543|111|45.73||111|1.17|1.01|17763052270|||||||Default queue 100|612803|6|1141|194617|110|38.73||82|4.52|1.30|17905300812|546379151|||||1|Default queue 100|612865|6|1340|248050|103|58.26||53|1.67|1.44|17852184576|877030208||||||Default queue 100|612712|6|1324|85273|103|45.87|2303|93|1.41|1.38|18000048306|155290029||||||Default queue 100|612824|6|766|145391|82|34.58||42|8.21|2.20|5295888000|433433283||||||Default queue 100|612960|6|750|145106|75|33.46||43|2.19|2.15|5266446720|433642827||||||Default queue 100|612937|6|969|193555|68|45.39||61|5.06|1.83|17884303485|546276521||||||Default queue 100|612598|6|317|267944|65|46.48||31|8.18|5.48|17734778880|118209186||||||Default queue 100|613041|6|873|105532|64|59.57||32|2.16|2.26|8933288124|344142648||||||Default queue 100|612773|6|767|105381|61|67.06||30|1.60|1.75|8833126180|344142130|||||1|Default queue 100|612610|6|546|144666|61|84.30||27|1.08|1.02|17620999680|442220912||||||Default queue 100|612685|6|628|133186|60|87.38||35|4.10|1.12|9580495040|399751289|||||1|Default queue 100|612788|6|547|321616|56|79.12||45|6.52|1.66|17788407439|337165||||||Default queue 100|612893|6|645|133337|53|86.31||37|4.40|1.09|9600196350|406352106||||||Default queue 100|613080|6|544|320293|52|78.85||45|8.35|2.35|17808987926|331978||||||Default queue 100|612556|6|345|255539|51|41.99||18|8.00|1.02|17673621876|17508586||||||Default queue 100|612484|6|89|70865|51|10.03||28|2.00|1.25|2281137664|9122228||||||Default queue 100|612851|6|555|145338|45|84.07||28|1.06|1.02|17719347200|445172970||||||Default queue 100|613064|6|361|269229|44|52.82||31|12.31|6.83|17811154794|118815247||||||Default queue 100|612985|6|342|251532|43|41.69||18|1.16|1.04|17359472387|17371268||||||Default queue 100|612697|6|489|32967|40|68.28||14|5.33|1.19|4466159616|17617781||||||Default queue 100|613136|6|539|33422|34|60.62||17|5.33|1.12|4388340736|17911308||||||Default queue 100|612701|6|280|34852|28|38.83||17|2.16|2.11|2262637056|335884548||||||Default queue 100|612474|6|100|8320|27|39.61||11|1.75|1.65|555664876|207840696||||||Default queue 100|613000|6|340|36254|27|30.96||25|2.29|1.48|2327129264|345500070||||||Default queue 100|612542|6|143|91678|26|34.19||8|16.00|2.47|2628332305|28434562||106496||||Default queue 100|612841|6|182|66710|26|50.24||10|16.00|1.09|4186139585|93481927||||||Default queue 100|612982|6|178|96866|23|29.45||10|4.54|1.14|2682115115|29025535||||||Default queue 100|612735|6|82|46834|22|67.67||6|1.19|1.14|2118225560|84722876||||||Default queue 100|612997|6|184|65311|20|50.29||10|5.33|1.07|4305919041|93479684||||||Default queue 100|612739|6|111|10468|14|40.95||10|1.11|1.05|692690655|||||||Default queue 100|612949|6|82|45769|13|75.04||5|16.00|1.08|2212584960|88563020||1580032||||Default queue 100|613075|6|97|7726|12|71.01||5|1.17|1.14|558897970|209038826||||||Default queue 100|613011|6|112|10566|10|40.34||10|1.10|1.03|700291120|||||||Default queue 100|612539|6|61|10927|10|97.11||4|1.03|1.02|504275072|||||||Default queue 100|612620|6|45|6741|9|86.25||4|16.00|1.29|182856708|||||||Default queue 100|613055|6|76|63337|9|37.88||5|1.84|1.79|2027365376|8104808||||||Default queue 100|612656|6|38|7444|8|42.22||3|2.00|1.04|202308759|10891097||||||Default queue 100|612978|6|80|11900|7|84.16||7|1.11|1.09|549471104|||||||Default queue 100|612553|6|16|34400|6|77.45||2|1.14|1.12|2259392170|||||||Default queue 100|612975|6|14|30295|3|41.52||3|1.12|1.13|1985047432|||||||Default queue 100|612863|6|8|5418|2|79.85||1|1.34|1.41|146823980|||||||Default queue 100|612645|6|1|0|2|2.85||1|16.00||||||||11|Default queue 100|612888|6|7|5565|2|37.66||1|3.20|1.58|151263043|8110084||||||Default queue 100|612854|6|||1||||||||||||31|Default queue 100|613068|6||0|1|||1|||100||||||18|Default queue 100|613089|6|||1||||||||||||27|Default queue 100|613156|6|1|0|1|21.39||1|16.00||||||||65|Default queue 100|612784|6|||1||||||||||||39|Default queue 100|612540|6|1|24|1|90.79||1|2.51|3.33|1112387|||||||Default queue 100|612963|6|||1||||||||||||73|Default queue 100|612654|6|1|24|1|75.80||1|2.53|2.00|||||||2|Default queue 100|612757|6|1|0|1|15.13||1|4.00||||||||64|Default queue 100|612799|6|||1||||||||||||37|Default queue 100|612886|6|1|24|1|91.79||1|2.67|2.00||||||||Default queue 100|612836|6|1|0|1|271.74||1|16.00||||||||17|Default queue 100|612663|6||0|1|||1|||||||||91|Default queue 100|613104|6|1|0|1|30.36||1|16.00||||||||181|Default queue (66 rows)
