Skip to content

Instantly share code, notes, and snippets.

@aalexandrov
Created October 15, 2022 10:12
Show Gist options
  • Save aalexandrov/726a5857fcd27f39128d83d4846bc7eb to your computer and use it in GitHub Desktop.
Save aalexandrov/726a5857fcd27f39128d83d4846bc7eb to your computer and use it in GitHub Desktop.
Plan diff
Return
Union
Map (null, null)
Union
Project (#0..=#3)
Negate
Join on=(#0 = #4)
Filter (#0 > #2)
Get l0
Distinct group_by=[#0]
Get l1
Filter (#0 > #2)
Get l0
Filter (#0 > #2)
Get l1
With
cte l1 =
Join on=(#0 = #4)
Filter (#0) IS NOT NULL
Get l0
Filter (#0) IS NOT NULL
Get materialize.public.t
cte l0 =
Join on=(#1 = #3)
Filter (#1) IS NOT NULL
Get materialize.public.r
Filter (#1) IS NOT NULL
Get materialize.public.s
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment