Timeline for How to improve the SQL query or change the table structure in postgresql?
Current License: CC BY-SA 3.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 7, 2020 at 22:25 | history | edited | CommunityBot |
added [postgresql-performance] to 571 questions - Shog9 (Id=1924)
|
|
| Aug 18, 2017 at 7:04 | history | edited | Krishna Rani Sahoo | CC BY-SA 3.0 |
after adding two new indexes
|
| Aug 18, 2017 at 5:56 | history | edited | Krishna Rani Sahoo | CC BY-SA 3.0 |
second Explain plan after modification in the brands table
|
| Aug 17, 2017 at 16:12 | answer | added | indiri | timeline score: 0 | |
| Aug 11, 2017 at 15:25 | answer | added | Evan Carroll | timeline score: 1 | |
| Aug 11, 2017 at 15:19 | comment | added | Evan Carroll |
Can you output the result of \d brands and \d products?
|
|
| Aug 11, 2017 at 15:15 | comment | added | RDFozz |
It looks like there's more than one row in brands for each row in products - note that before the join we have 300K rows in products and 42k in brands - after the join, we have 65 million rows. Does that make sense, given what you know about the tables in question? Could there be different brands.id values for the same lower(brands.name) value?
|
|
| Aug 11, 2017 at 15:07 | comment | added | Krishna Rani Sahoo | products.created_at, product.brand and brands.name are indexed. But the products.lower(brand) is not indexed | |
| Aug 11, 2017 at 15:05 | comment | added | bma |
Do you have indexes over brands.lower(brand) and products.created_at? Can you post the DDL for those tables?
|
|
| Aug 11, 2017 at 15:00 | history | edited | Krishna Rani Sahoo | CC BY-SA 3.0 |
Added explain of the sql query
|
| Aug 11, 2017 at 14:48 | review | First posts | |||
| Aug 11, 2017 at 14:56 | |||||
| Aug 11, 2017 at 14:47 | history | asked | Krishna Rani Sahoo | CC BY-SA 3.0 |