1. 07 Jun, 2021 3 commits
  2. 07 May, 2021 3 commits
    • faried nawaz's avatar
      a better query to delete from hashtags · 5be9d139
      faried nawaz authored
      old query:
      
      Delete on hashtags  (cost=5089.81..5521.63 rows=6160 width=18)
         ->  Hash Semi Join  (cost=5089.81..5521.63 rows=6160 width=18)
               Hash Cond: (hashtags.id = ht.id)
               ->  Seq Scan on hashtags  (cost=0.00..317.28 rows=17528 width=14)
               ->  Hash  (cost=5012.81..5012.81 rows=6160 width=20)
                     ->  Merge Anti Join  (cost=0.70..5012.81 rows=6160 width=20)
                           Merge Cond: (ht.id = hto.hashtag_id)
                           ->  Index Scan using hashtags_pkey on hashtags ht  (cost=0.29..610.53 rows=17528 width=14)
                           ->  Index Scan using hashtags_objects_pkey on hashtags_objects hto  (cost=0.42..3506.48 rows=68158 width=14)
      
      new query:
      
      Delete on hashtags ht  (cost=0.70..5012.81 rows=6160 width=12)
         ->  Merge Anti Join  (cost=0.70..5012.81 rows=6160 width=12)
               Merge Cond: (ht.id = hto.hashtag_id)
               ->  Index Scan using hashtags_pkey on hashtags ht  (cost=0.29..610.53 rows=17528 width=14)
               ->  Index Scan using hashtags_objects_pkey on hashtags_objects hto  (cost=0.42..3506.48 rows=68158 width=14)
      5be9d139
    • faried nawaz's avatar
    • faried nawaz's avatar
  3. 04 May, 2021 2 commits
  4. 03 May, 2021 3 commits
  5. 01 May, 2021 1 commit
  6. 30 Apr, 2021 5 commits
  7. 29 Apr, 2021 6 commits
  8. 28 Apr, 2021 1 commit
  9. 27 Apr, 2021 1 commit
  10. 23 Apr, 2021 1 commit
  11. 22 Apr, 2021 6 commits
  12. 20 Apr, 2021 2 commits
  13. 19 Apr, 2021 5 commits
  14. 18 Apr, 2021 1 commit