Hans-Jurgen Schonig

Hans-Jurgen Schonig has been in the PostgreSQL business since 2000. His company, Cybertec Schonig & Schonig GmbH (http://www.postgresql-support.de), serves clients around the globe, providing 24/7 support, replication, development, consulting, and training. He has written numerous books on PostgreSQL.

Quotes

Maryna Lysenko 💙💛has quoted2 years ago
table in PostgreSQL can hold up to 1600 columns
Maryna Lysenko 💙💛has quoted2 years ago
SELECT schemaname, relname, seq_scan, seq_tup_read,
idx_scan, seq_tup_read / seq_scan
FROM pg_stat_user_tables
WHERE seq_scan > 0
ORDER BY seq_tup_read DESC;
The query provides us with schemaname and relname to identify the table inside the database. The seq_scan field will return the number of times the table has been read sequentially. During those sequential scans, the database had to read seq_tup_read rows. The idx_scan field informs us about the number of index scans, and finally, the average number of rows needed by seq_scan is displayed.
Maryna Lysenko 💙💛has quoted2 years ago
test=# \d pg_stat_user_indexes
View "pg_catalog.pg_stat_user_indexes"

Impressions

Maryna Lysenko 💙💛shared an impression2 years ago
👍Worth reading

  • Hans-Jurgen Schonig
    Troubleshooting PostgreSQL
    • 3
    • 11
    • 1
    • 1
    Books
  • fb2epub
    Drag & drop your files (not more than 5 at once)