Skip to content

Instantly share code, notes, and snippets.

@sunaurus
sunaurus / gist:856e03165bb0c0010505afeebde45230
Last active July 18, 2023 08:23
Front page "subscribed" feed query plans

Original query

Limit  (cost=1276.73..1276.78 rows=20 width=3173) (actual time=3501.235..3501.302 rows=20 loops=1)
  ->  Sort  (cost=1276.73..1277.75 rows=408 width=3173) (actual time=3501.234..3501.296 rows=20 loops=1)
"        Sort Key: post_aggregates.featured_local DESC, post_aggregates.hot_rank DESC"
        Sort Method: top-N heapsort  Memory: 101kB
        ->  Nested Loop  (cost=21.91..1265.87 rows=408 width=3173) (actual time=33.530..3351.905 rows=25841 loops=1)
              ->  Nested Loop Left Join  (cost=21.47..1239.54 rows=395 width=3173) (actual time=29.344..3280.371 rows=25841 loops=1)
                    ->  Nested Loop Left Join  (cost=21.05..1053.98 rows=395 width=3165) (actual time=29.132..2165.523 rows=25841 loops=1)
@sunaurus
sunaurus / Audio-Merge.md
Created October 6, 2019 09:48 — forked from shadowmoose/Audio-Merge.md
Merge multiple audio tracks inside a video file

About

This is a simple script to combine two of a video file's audio tracks into one. It doesn't impact the video's quality.

To make things even more simple, it only prompts for an input/output video using file selectors. The rest is handled automatically.

This is a simple utility to rapidly "fix" videos with split audio tracks, such as those recorded by ShadowPlay or OBS.

To use this script, simply copy/paste the "merge.ps1" code below into a new file named "merge.ps1", then launch it.

Keybase proof

I hereby claim:

  • I am sunaurus on github.
  • I am sunaurus (https://keybase.io/sunaurus) on keybase.
  • I have a public key ASAt-odqqXX3e4X6ZVHiPlHtf37kWn2CLUmiaI5mVRdEawo

To claim this, I am signing this object: