Timeline for Execution Performance Issue with Similar Query
Current License: CC BY-SA 3.0
27 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 3, 2022 at 3:00 | history | tweeted | twitter.com/StackDBAs/status/1554663372322488321 | ||
| Aug 3, 2022 at 2:07 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Apr 2, 2022 at 2:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Nov 26, 2021 at 10:04 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 28, 2021 at 13:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Mar 28, 2021 at 21:04 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Nov 27, 2020 at 9:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 10, 2020 at 9:08 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 23, 2020 at 23:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 7, 2020 at 22:25 | history | edited | CommunityBot |
added [postgresql-performance] to 571 questions - Shog9 (Id=1924)
|
|
| Oct 13, 2019 at 17:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 14, 2019 at 8:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 10, 2019 at 21:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 1, 2017 at 16:35 | history | edited | Leandro Barreto | CC BY-SA 3.0 |
Database specs
|
| Feb 1, 2017 at 3:02 | answer | added | jjanes | timeline score: 0 | |
| Jan 31, 2017 at 23:23 | history | edited | Evan Carroll | CC BY-SA 3.0 |
added 14 characters in body
|
| Jan 31, 2017 at 23:08 | answer | added | Anup Shah | timeline score: 1 | |
| Jan 31, 2017 at 22:08 | comment | added | Leandro Barreto |
Well, if I remove the join and run foi.fk_dim_order_item_status in (12,43,53 ...) with the IDs that satisfy dois.is_reserved = 1, I receive the same slow results.
|
|
| Jan 31, 2017 at 21:50 | comment | added | user1822 |
What happens if you compare is_reserved correctly with a number? where dois.is_reserved = 1
|
|
| Jan 31, 2017 at 21:44 | history | edited | Leandro Barreto | CC BY-SA 3.0 |
Extra data on the tables
|
| Jan 31, 2017 at 21:23 | comment | added | ypercubeᵀᴹ |
Show us the CREATE TABLE statements (and indexes). Or the output of \d tablename for both of them.
|
|
| Jan 31, 2017 at 21:10 | comment | added | Leandro Barreto | Thanks for the quick feedback. I updated the question with the information. | |
| Jan 31, 2017 at 21:09 | history | edited | Leandro Barreto | CC BY-SA 3.0 |
Updated output information
|
| Jan 31, 2017 at 19:34 | answer | added | Evan Carroll | timeline score: 0 | |
| Jan 31, 2017 at 15:46 | comment | added | Daniel Vérité |
Please post EXPLAIN (ANALYZE, BUFFERS) as mentioned in wiki.postgresql.org/wiki/Slow_Query_Questions
|
|
| Jan 31, 2017 at 12:53 | review | First posts | |||
| Jan 31, 2017 at 13:10 | |||||
| Jan 31, 2017 at 12:49 | history | asked | Leandro Barreto | CC BY-SA 3.0 |