Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 80701

A database structure that can improve the speed of queries at the cost of disk space and slower inserts/updates. It stores a copy of one or more columns sorted but structures the data differently to allow faster access.

1
vote
1answer
I'm using the following query to find unused indexes: SELECT PSUI.indexrelid::regclass AS IndexName ,PSUI.relid::regclass AS TableName FROM pg_stat_user_indexes AS PSUI JOIN pg_index AS PI ON PS …
asked May 2 '16 by Gonzalo Vasquez
2
votes
2answers
We have a pretty big database (around 700GB of data), which has been inherited to us, and has had several DBAs. With time we've realized that there are several missing foreign keys and indexes. I'd …
asked Nov 24 '15 by Gonzalo Vasquez
0
votes
1answer
,distribucion.pk_distribucion_asignacion} Too check that the index are actually duplicate, I manually see the columns involving each reported index, with this query: select * from pg_indexes where …
asked May 2 '16 by Gonzalo Vasquez
0
votes
1answer
rows=1 width=67) -> Nested Loop (cost=0.00..14.92 rows=1 width=63) -> Nested Loop (cost=0.00..14.58 rows=1 width=63) -> Index Scan using … fki_avl_vehiculo_equipo_imei on avl_vehiculo_equipo (cost=0.00..7.28 rows=1 width=12) Index Cond: (imei = 1234) -> Index Scan using index_avl_vehiculo_id on avl_vehiculo (cost=0.00 …
asked Nov 16 '15 by Gonzalo Vasquez