Difference between revisions of "Index (PostgreSQL)"

From wikieduonline
Jump to navigation Jump to search
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
+
* https://www.postgresql.org/docs/current/indexes.html
  
 
  SELECT  
 
  SELECT  
Line 18: Line 18:
 
  ---------+-----------------------------+---------------
 
  ---------+-----------------------------+---------------
 
  (0 rows)
 
  (0 rows)
 +
 +
[[\di]]
 +
Did not find any relations.
 +
 +
  
 
== Related ==
 
== Related ==
 
* [[Database index]]
 
* [[Database index]]
 +
* [[Schema]]
 +
* [[PostgreSQL Index Locking]]
  
 
== See also ==
 
== See also ==
* {{SQL}}
+
* {{CREATE INDEX}}
 
* {{PostgreSQL}}
 
* {{PostgreSQL}}
  
 
[[Category:PostgreSQL]]
 
[[Category:PostgreSQL]]

Latest revision as of 10:24, 11 July 2023

SELECT 
  relname, 
  100 * idx_scan / (seq_scan + idx_scan) percent_of_times_index_used, 
  n_live_tup rows_in_table
FROM 
  pg_stat_user_tables
WHERE 
    seq_scan + idx_scan > 0 
ORDER BY 
  n_live_tup DESC;

Ref: https://www.craigkerstiens.com/2012/10/01/understanding-postgres-performance/


relname | percent_of_times_index_used | rows_in_table
---------+-----------------------------+---------------
(0 rows)
\di
Did not find any relations.


Related[edit]

See also[edit]

Advertising: