Well let's start with the REALLY long number, for one it's actually two numbers separated by two decimal points. Cost isn't the exact cost of how long it will run end to end, but is instead the relative cost of what it will take to execute the parts of the query. > XN Seq Scan on category (cost=0.00.0.11 rows=11 width=10)Įnter fullscreen mode Exit fullscreen modeĪs you can see, the word cost is found everywhere in the explain plan. > XN Seq Scan on listing (cost=.97 rows=192497 width=14) Merge Cond: ("outer".listid = "inner".listid) Hash Cond: ("outer".eventid = "inner".eventid) Hash Cond: ("outer".venueid = "inner".venueid) Hash Cond: ("outer".buyerid = "inner".userid) Hash Cond: ("outer".dateid = "inner".dateid) Hash Cond: ("outer".catid = "inner".catid) Sort Key: category.catname, sum(sales.pricepaid) Merge Key: category.catname, sum(sales.pricepaid)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |