Skip to content

Instantly share code, notes, and snippets.

@onderkalaci
Created October 8, 2020 11:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save onderkalaci/2b40a18d989da389ee4fb631e1ad7c0e to your computer and use it in GitHub Desktop.
Save onderkalaci/2b40a18d989da389ee4fb631e1ad7c0e to your computer and use it in GitHub Desktop.
pg_config
BINDIR = /Users/onderkalaci/Documents/citus_code/pgenv/pgsql-13.0/bin
DOCDIR = /Users/onderkalaci/Documents/citus_code/pgenv/pgsql-13.0/share/doc
HTMLDIR = /Users/onderkalaci/Documents/citus_code/pgenv/pgsql-13.0/share/doc
INCLUDEDIR = /Users/onderkalaci/Documents/citus_code/pgenv/pgsql-13.0/include
PKGINCLUDEDIR = /Users/onderkalaci/Documents/citus_code/pgenv/pgsql-13.0/include
INCLUDEDIR-SERVER = /Users/onderkalaci/Documents/citus_code/pgenv/pgsql-13.0/include/server
LIBDIR = /Users/onderkalaci/Documents/citus_code/pgenv/pgsql-13.0/lib
PKGLIBDIR = /Users/onderkalaci/Documents/citus_code/pgenv/pgsql-13.0/lib
LOCALEDIR = /Users/onderkalaci/Documents/citus_code/pgenv/pgsql-13.0/share/locale
MANDIR = /Users/onderkalaci/Documents/citus_code/pgenv/pgsql-13.0/share/man
SHAREDIR = /Users/onderkalaci/Documents/citus_code/pgenv/pgsql-13.0/share
SYSCONFDIR = /Users/onderkalaci/Documents/citus_code/pgenv/pgsql-13.0/etc
PGXS = /Users/onderkalaci/Documents/citus_code/pgenv/pgsql-13.0/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--prefix=/Users/onderkalaci/Documents/citus_code/pgenv/pgsql-13.0' '--enable-debug' '--enable-cassert' 'CFLAGS=-ggdb -Og -g3 -fno-omit-frame-pointer' '--with-openssl' '--with-icu' 'LDFLAGS=-L/usr/local/opt/readline/lib -L/usr/local/opt/openssl/lib ' 'CPPFLAGS=-I/usr/local/opt/readline/include -I/usr/local/opt/openssl/include/ ' 'PKG_CONFIG_PATH=/usr/local/opt/icu4c/lib/pkgconfig'
CC = gcc
CPPFLAGS = -I/usr/local/Cellar/icu4c/66.1/include -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.14.sdk -I/usr/local/opt/readline/include -I/usr/local/opt/openssl/include/
CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -Wno-unused-command-line-argument -g -ggdb -Og -g3 -fno-omit-frame-pointer
CFLAGS_SL =
LDFLAGS = -L/usr/local/opt/readline/lib -L/usr/local/opt/openssl/lib -Wl,-dead_strip_dylibs
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgcommon -lpgport -lssl -lcrypto -lz -lreadline -lm
VERSION = PostgreSQL 13.0
SELECT version();
version
-------------------------------------------------------------------------------------------------------------------
PostgreSQL 13.0 on x86_64-apple-darwin18.7.0, compiled by Apple clang version 11.0.0 (clang-1100.0.33.17), 64-bit
(1 row)
Time: 0.772 ms
CREATE TABLE users_table (user_id int, time timestamp, value_1 int, value_2 int, value_3 float, value_4 bigint);
-- 250 relations work fine
SELECT count(*) FROM users_table LEFT JOIN users_table u0 USING (user_id) LEFT JOIN users_table u1 USING (user_id) LEFT JOIN users_table u2 USING (user_id) LEFT JOIN users_table u3 USING (user_id) LEFT JOIN users_table u4 USING (user_id) LEFT JOIN users_table u5 USING (user_id) LEFT JOIN users_table u6 USING (user_id) LEFT JOIN users_table u7 USING (user_id) LEFT JOIN users_table u8 USING (user_id) LEFT JOIN users_table u9 USING (user_id) LEFT JOIN users_table u10 USING (user_id) LEFT JOIN users_table u11 USING (user_id) LEFT JOIN users_table u12 USING (user_id) LEFT JOIN users_table u13 USING (user_id) LEFT JOIN users_table u14 USING (user_id) LEFT JOIN users_table u15 USING (user_id) LEFT JOIN users_table u16 USING (user_id) LEFT JOIN users_table u17 USING (user_id) LEFT JOIN users_table u18 USING (user_id) LEFT JOIN users_table u19 USING (user_id) LEFT JOIN users_table u20 USING (user_id) LEFT JOIN users_table u21 USING (user_id) LEFT JOIN users_table u22 USING (user_id) LEFT JOIN users_table u23 USING (user_id) LEFT JOIN users_table u24 USING (user_id) LEFT JOIN users_table u25 USING (user_id) LEFT JOIN users_table u26 USING (user_id) LEFT JOIN users_table u27 USING (user_id) LEFT JOIN users_table u28 USING (user_id) LEFT JOIN users_table u29 USING (user_id) LEFT JOIN users_table u30 USING (user_id) LEFT JOIN users_table u31 USING (user_id) LEFT JOIN users_table u32 USING (user_id) LEFT JOIN users_table u33 USING (user_id) LEFT JOIN users_table u34 USING (user_id) LEFT JOIN users_table u35 USING (user_id) LEFT JOIN users_table u36 USING (user_id) LEFT JOIN users_table u37 USING (user_id) LEFT JOIN users_table u38 USING (user_id) LEFT JOIN users_table u39 USING (user_id) LEFT JOIN users_table u40 USING (user_id) LEFT JOIN users_table u41 USING (user_id) LEFT JOIN users_table u42 USING (user_id) LEFT JOIN users_table u43 USING (user_id) LEFT JOIN users_table u44 USING (user_id) LEFT JOIN users_table u45 USING (user_id) LEFT JOIN users_table u46 USING (user_id) LEFT JOIN users_table u47 USING (user_id) LEFT JOIN users_table u48 USING (user_id) LEFT JOIN users_table u49 USING (user_id) LEFT JOIN users_table u50 USING (user_id) LEFT JOIN users_table u51 USING (user_id) LEFT JOIN users_table u52 USING (user_id) LEFT JOIN users_table u53 USING (user_id) LEFT JOIN users_table u54 USING (user_id) LEFT JOIN users_table u55 USING (user_id) LEFT JOIN users_table u56 USING (user_id) LEFT JOIN users_table u57 USING (user_id) LEFT JOIN users_table u58 USING (user_id) LEFT JOIN users_table u59 USING (user_id) LEFT JOIN users_table u60 USING (user_id) LEFT JOIN users_table u61 USING (user_id) LEFT JOIN users_table u62 USING (user_id) LEFT JOIN users_table u63 USING (user_id) LEFT JOIN users_table u64 USING (user_id) LEFT JOIN users_table u65 USING (user_id) LEFT JOIN users_table u66 USING (user_id) LEFT JOIN users_table u67 USING (user_id) LEFT JOIN users_table u68 USING (user_id) LEFT JOIN users_table u69 USING (user_id) LEFT JOIN users_table u70 USING (user_id) LEFT JOIN users_table u71 USING (user_id) LEFT JOIN users_table u72 USING (user_id) LEFT JOIN users_table u73 USING (user_id) LEFT JOIN users_table u74 USING (user_id) LEFT JOIN users_table u75 USING (user_id) LEFT JOIN users_table u76 USING (user_id) LEFT JOIN users_table u77 USING (user_id) LEFT JOIN users_table u78 USING (user_id) LEFT JOIN users_table u79 USING (user_id) LEFT JOIN users_table u80 USING (user_id) LEFT JOIN users_table u81 USING (user_id) LEFT JOIN users_table u82 USING (user_id) LEFT JOIN users_table u83 USING (user_id) LEFT JOIN users_table u84 USING (user_id) LEFT JOIN users_table u85 USING (user_id) LEFT JOIN users_table u86 USING (user_id) LEFT JOIN users_table u87 USING (user_id) LEFT JOIN users_table u88 USING (user_id) LEFT JOIN users_table u89 USING (user_id) LEFT JOIN users_table u90 USING (user_id) LEFT JOIN users_table u91 USING (user_id) LEFT JOIN users_table u92 USING (user_id) LEFT JOIN users_table u93 USING (user_id) LEFT JOIN users_table u94 USING (user_id) LEFT JOIN users_table u95 USING (user_id) LEFT JOIN users_table u96 USING (user_id) LEFT JOIN users_table u97 USING (user_id) LEFT JOIN users_table u98 USING (user_id) LEFT JOIN users_table u99 USING (user_id) LEFT JOIN users_table u100 USING (user_id) LEFT JOIN users_table u101 USING (user_id) LEFT JOIN users_table u102 USING (user_id) LEFT JOIN users_table u103 USING (user_id) LEFT JOIN users_table u104 USING (user_id) LEFT JOIN users_table u105 USING (user_id) LEFT JOIN users_table u106 USING (user_id) LEFT JOIN users_table u107 USING (user_id) LEFT JOIN users_table u108 USING (user_id) LEFT JOIN users_table u109 USING (user_id) LEFT JOIN users_table u110 USING (user_id) LEFT JOIN users_table u111 USING (user_id) LEFT JOIN users_table u112 USING (user_id) LEFT JOIN users_table u113 USING (user_id) LEFT JOIN users_table u114 USING (user_id) LEFT JOIN users_table u115 USING (user_id) LEFT JOIN users_table u116 USING (user_id) LEFT JOIN users_table u117 USING (user_id) LEFT JOIN users_table u118 USING (user_id) LEFT JOIN users_table u119 USING (user_id) LEFT JOIN users_table u120 USING (user_id) LEFT JOIN users_table u121 USING (user_id) LEFT JOIN users_table u122 USING (user_id) LEFT JOIN users_table u123 USING (user_id) LEFT JOIN users_table u124 USING (user_id) LEFT JOIN users_table u125 USING (user_id) LEFT JOIN users_table u126 USING (user_id) LEFT JOIN users_table u127 USING (user_id) LEFT JOIN users_table u128 USING (user_id) LEFT JOIN users_table u129 USING (user_id) LEFT JOIN users_table u130 USING (user_id) LEFT JOIN users_table u131 USING (user_id) LEFT JOIN users_table u132 USING (user_id) LEFT JOIN users_table u133 USING (user_id) LEFT JOIN users_table u134 USING (user_id) LEFT JOIN users_table u135 USING (user_id) LEFT JOIN users_table u136 USING (user_id) LEFT JOIN users_table u137 USING (user_id) LEFT JOIN users_table u138 USING (user_id) LEFT JOIN users_table u139 USING (user_id) LEFT JOIN users_table u140 USING (user_id) LEFT JOIN users_table u141 USING (user_id) LEFT JOIN users_table u142 USING (user_id) LEFT JOIN users_table u143 USING (user_id) LEFT JOIN users_table u144 USING (user_id) LEFT JOIN users_table u145 USING (user_id) LEFT JOIN users_table u146 USING (user_id) LEFT JOIN users_table u147 USING (user_id) LEFT JOIN users_table u148 USING (user_id) LEFT JOIN users_table u149 USING (user_id) LEFT JOIN users_table u150 USING (user_id) LEFT JOIN users_table u151 USING (user_id) LEFT JOIN users_table u152 USING (user_id) LEFT JOIN users_table u153 USING (user_id) LEFT JOIN users_table u154 USING (user_id) LEFT JOIN users_table u155 USING (user_id) LEFT JOIN users_table u156 USING (user_id) LEFT JOIN users_table u157 USING (user_id) LEFT JOIN users_table u158 USING (user_id) LEFT JOIN users_table u159 USING (user_id) LEFT JOIN users_table u160 USING (user_id) LEFT JOIN users_table u161 USING (user_id) LEFT JOIN users_table u162 USING (user_id) LEFT JOIN users_table u163 USING (user_id) LEFT JOIN users_table u164 USING (user_id) LEFT JOIN users_table u165 USING (user_id) LEFT JOIN users_table u166 USING (user_id) LEFT JOIN users_table u167 USING (user_id) LEFT JOIN users_table u168 USING (user_id) LEFT JOIN users_table u169 USING (user_id) LEFT JOIN users_table u170 USING (user_id) LEFT JOIN users_table u171 USING (user_id) LEFT JOIN users_table u172 USING (user_id) LEFT JOIN users_table u173 USING (user_id) LEFT JOIN users_table u174 USING (user_id) LEFT JOIN users_table u175 USING (user_id) LEFT JOIN users_table u176 USING (user_id) LEFT JOIN users_table u177 USING (user_id) LEFT JOIN users_table u178 USING (user_id) LEFT JOIN users_table u179 USING (user_id) LEFT JOIN users_table u180 USING (user_id) LEFT JOIN users_table u181 USING (user_id) LEFT JOIN users_table u182 USING (user_id) LEFT JOIN users_table u183 USING (user_id) LEFT JOIN users_table u184 USING (user_id) LEFT JOIN users_table u185 USING (user_id) LEFT JOIN users_table u186 USING (user_id) LEFT JOIN users_table u187 USING (user_id) LEFT JOIN users_table u188 USING (user_id) LEFT JOIN users_table u189 USING (user_id) LEFT JOIN users_table u190 USING (user_id) LEFT JOIN users_table u191 USING (user_id) LEFT JOIN users_table u192 USING (user_id) LEFT JOIN users_table u193 USING (user_id) LEFT JOIN users_table u194 USING (user_id) LEFT JOIN users_table u195 USING (user_id) LEFT JOIN users_table u196 USING (user_id) LEFT JOIN users_table u197 USING (user_id) LEFT JOIN users_table u198 USING (user_id) LEFT JOIN users_table u199 USING (user_id) LEFT JOIN users_table u200 USING (user_id) LEFT JOIN users_table u201 USING (user_id) LEFT JOIN users_table u202 USING (user_id) LEFT JOIN users_table u203 USING (user_id) LEFT JOIN users_table u204 USING (user_id) LEFT JOIN users_table u205 USING (user_id) LEFT JOIN users_table u206 USING (user_id) LEFT JOIN users_table u207 USING (user_id) LEFT JOIN users_table u208 USING (user_id) LEFT JOIN users_table u209 USING (user_id) LEFT JOIN users_table u210 USING (user_id) LEFT JOIN users_table u211 USING (user_id) LEFT JOIN users_table u212 USING (user_id) LEFT JOIN users_table u213 USING (user_id) LEFT JOIN users_table u214 USING (user_id) LEFT JOIN users_table u215 USING (user_id) LEFT JOIN users_table u216 USING (user_id) LEFT JOIN users_table u217 USING (user_id) LEFT JOIN users_table u218 USING (user_id) LEFT JOIN users_table u219 USING (user_id) LEFT JOIN users_table u220 USING (user_id) LEFT JOIN users_table u221 USING (user_id) LEFT JOIN users_table u222 USING (user_id) LEFT JOIN users_table u223 USING (user_id) LEFT JOIN users_table u224 USING (user_id) LEFT JOIN users_table u225 USING (user_id) LEFT JOIN users_table u226 USING (user_id) LEFT JOIN users_table u227 USING (user_id) LEFT JOIN users_table u228 USING (user_id) LEFT JOIN users_table u229 USING (user_id) LEFT JOIN users_table u230 USING (user_id) LEFT JOIN users_table u231 USING (user_id) LEFT JOIN users_table u232 USING (user_id) LEFT JOIN users_table u233 USING (user_id) LEFT JOIN users_table u234 USING (user_id) LEFT JOIN users_table u235 USING (user_id) LEFT JOIN users_table u236 USING (user_id) LEFT JOIN users_table u237 USING (user_id) LEFT JOIN users_table u238 USING (user_id) LEFT JOIN users_table u239 USING (user_id) LEFT JOIN users_table u240 USING (user_id) LEFT JOIN users_table u241 USING (user_id) LEFT JOIN users_table u242 USING (user_id) LEFT JOIN users_table u243 USING (user_id) LEFT JOIN users_table u244 USING (user_id) LEFT JOIN users_table u245 USING (user_id) LEFT JOIN users_table u246 USING (user_id) LEFT JOIN users_table u247 USING (user_id) LEFT JOIN users_table u248 USING (user_id) LEFT JOIN users_table u249 USING (user_id)
-- >500 tables LEFT JOIN crashes
SELECT count(*) FROM users_table LEFT JOIN users_table u0 USING (user_id) LEFT JOIN users_table u1 USING (user_id) LEFT JOIN users_table u2 USING (user_id) LEFT JOIN users_table u3 USING (user_id) LEFT JOIN users_table u4 USING (user_id) LEFT JOIN users_table u5 USING (user_id) LEFT JOIN users_table u6 USING (user_id) LEFT JOIN users_table u7 USING (user_id) LEFT JOIN users_table u8 USING (user_id) LEFT JOIN users_table u9 USING (user_id) LEFT JOIN users_table u10 USING (user_id) LEFT JOIN users_table u11 USING (user_id) LEFT JOIN users_table u12 USING (user_id) LEFT JOIN users_table u13 USING (user_id) LEFT JOIN users_table u14 USING (user_id) LEFT JOIN users_table u15 USING (user_id) LEFT JOIN users_table u16 USING (user_id) LEFT JOIN users_table u17 USING (user_id) LEFT JOIN users_table u18 USING (user_id) LEFT JOIN users_table u19 USING (user_id) LEFT JOIN users_table u20 USING (user_id) LEFT JOIN users_table u21 USING (user_id) LEFT JOIN users_table u22 USING (user_id) LEFT JOIN users_table u23 USING (user_id) LEFT JOIN users_table u24 USING (user_id) LEFT JOIN users_table u25 USING (user_id) LEFT JOIN users_table u26 USING (user_id) LEFT JOIN users_table u27 USING (user_id) LEFT JOIN users_table u28 USING (user_id) LEFT JOIN users_table u29 USING (user_id) LEFT JOIN users_table u30 USING (user_id) LEFT JOIN users_table u31 USING (user_id) LEFT JOIN users_table u32 USING (user_id) LEFT JOIN users_table u33 USING (user_id) LEFT JOIN users_table u34 USING (user_id) LEFT JOIN users_table u35 USING (user_id) LEFT JOIN users_table u36 USING (user_id) LEFT JOIN users_table u37 USING (user_id) LEFT JOIN users_table u38 USING (user_id) LEFT JOIN users_table u39 USING (user_id) LEFT JOIN users_table u40 USING (user_id) LEFT JOIN users_table u41 USING (user_id) LEFT JOIN users_table u42 USING (user_id) LEFT JOIN users_table u43 USING (user_id) LEFT JOIN users_table u44 USING (user_id) LEFT JOIN users_table u45 USING (user_id) LEFT JOIN users_table u46 USING (user_id) LEFT JOIN users_table u47 USING (user_id) LEFT JOIN users_table u48 USING (user_id) LEFT JOIN users_table u49 USING (user_id) LEFT JOIN users_table u50 USING (user_id) LEFT JOIN users_table u51 USING (user_id) LEFT JOIN users_table u52 USING (user_id) LEFT JOIN users_table u53 USING (user_id) LEFT JOIN users_table u54 USING (user_id) LEFT JOIN users_table u55 USING (user_id) LEFT JOIN users_table u56 USING (user_id) LEFT JOIN users_table u57 USING (user_id) LEFT JOIN users_table u58 USING (user_id) LEFT JOIN users_table u59 USING (user_id) LEFT JOIN users_table u60 USING (user_id) LEFT JOIN users_table u61 USING (user_id) LEFT JOIN users_table u62 USING (user_id) LEFT JOIN users_table u63 USING (user_id) LEFT JOIN users_table u64 USING (user_id) LEFT JOIN users_table u65 USING (user_id) LEFT JOIN users_table u66 USING (user_id) LEFT JOIN users_table u67 USING (user_id) LEFT JOIN users_table u68 USING (user_id) LEFT JOIN users_table u69 USING (user_id) LEFT JOIN users_table u70 USING (user_id) LEFT JOIN users_table u71 USING (user_id) LEFT JOIN users_table u72 USING (user_id) LEFT JOIN users_table u73 USING (user_id) LEFT JOIN users_table u74 USING (user_id) LEFT JOIN users_table u75 USING (user_id) LEFT JOIN users_table u76 USING (user_id) LEFT JOIN users_table u77 USING (user_id) LEFT JOIN users_table u78 USING (user_id) LEFT JOIN users_table u79 USING (user_id) LEFT JOIN users_table u80 USING (user_id) LEFT JOIN users_table u81 USING (user_id) LEFT JOIN users_table u82 USING (user_id) LEFT JOIN users_table u83 USING (user_id) LEFT JOIN users_table u84 USING (user_id) LEFT JOIN users_table u85 USING (user_id) LEFT JOIN users_table u86 USING (user_id) LEFT JOIN users_table u87 USING (user_id) LEFT JOIN users_table u88 USING (user_id) LEFT JOIN users_table u89 USING (user_id) LEFT JOIN users_table u90 USING (user_id) LEFT JOIN users_table u91 USING (user_id) LEFT JOIN users_table u92 USING (user_id) LEFT JOIN users_table u93 USING (user_id) LEFT JOIN users_table u94 USING (user_id) LEFT JOIN users_table u95 USING (user_id) LEFT JOIN users_table u96 USING (user_id) LEFT JOIN users_table u97 USING (user_id) LEFT JOIN users_table u98 USING (user_id) LEFT JOIN users_table u99 USING (user_id) LEFT JOIN users_table u100 USING (user_id) LEFT JOIN users_table u101 USING (user_id) LEFT JOIN users_table u102 USING (user_id) LEFT JOIN users_table u103 USING (user_id) LEFT JOIN users_table u104 USING (user_id) LEFT JOIN users_table u105 USING (user_id) LEFT JOIN users_table u106 USING (user_id) LEFT JOIN users_table u107 USING (user_id) LEFT JOIN users_table u108 USING (user_id) LEFT JOIN users_table u109 USING (user_id) LEFT JOIN users_table u110 USING (user_id) LEFT JOIN users_table u111 USING (user_id) LEFT JOIN users_table u112 USING (user_id) LEFT JOIN users_table u113 USING (user_id) LEFT JOIN users_table u114 USING (user_id) LEFT JOIN users_table u115 USING (user_id) LEFT JOIN users_table u116 USING (user_id) LEFT JOIN users_table u117 USING (user_id) LEFT JOIN users_table u118 USING (user_id) LEFT JOIN users_table u119 USING (user_id) LEFT JOIN users_table u120 USING (user_id) LEFT JOIN users_table u121 USING (user_id) LEFT JOIN users_table u122 USING (user_id) LEFT JOIN users_table u123 USING (user_id) LEFT JOIN users_table u124 USING (user_id) LEFT JOIN users_table u125 USING (user_id) LEFT JOIN users_table u126 USING (user_id) LEFT JOIN users_table u127 USING (user_id) LEFT JOIN users_table u128 USING (user_id) LEFT JOIN users_table u129 USING (user_id) LEFT JOIN users_table u130 USING (user_id) LEFT JOIN users_table u131 USING (user_id) LEFT JOIN users_table u132 USING (user_id) LEFT JOIN users_table u133 USING (user_id) LEFT JOIN users_table u134 USING (user_id) LEFT JOIN users_table u135 USING (user_id) LEFT JOIN users_table u136 USING (user_id) LEFT JOIN users_table u137 USING (user_id) LEFT JOIN users_table u138 USING (user_id) LEFT JOIN users_table u139 USING (user_id) LEFT JOIN users_table u140 USING (user_id) LEFT JOIN users_table u141 USING (user_id) LEFT JOIN users_table u142 USING (user_id) LEFT JOIN users_table u143 USING (user_id) LEFT JOIN users_table u144 USING (user_id) LEFT JOIN users_table u145 USING (user_id) LEFT JOIN users_table u146 USING (user_id) LEFT JOIN users_table u147 USING (user_id) LEFT JOIN users_table u148 USING (user_id) LEFT JOIN users_table u149 USING (user_id) LEFT JOIN users_table u150 USING (user_id) LEFT JOIN users_table u151 USING (user_id) LEFT JOIN users_table u152 USING (user_id) LEFT JOIN users_table u153 USING (user_id) LEFT JOIN users_table u154 USING (user_id) LEFT JOIN users_table u155 USING (user_id) LEFT JOIN users_table u156 USING (user_id) LEFT JOIN users_table u157 USING (user_id) LEFT JOIN users_table u158 USING (user_id) LEFT JOIN users_table u159 USING (user_id) LEFT JOIN users_table u160 USING (user_id) LEFT JOIN users_table u161 USING (user_id) LEFT JOIN users_table u162 USING (user_id) LEFT JOIN users_table u163 USING (user_id) LEFT JOIN users_table u164 USING (user_id) LEFT JOIN users_table u165 USING (user_id) LEFT JOIN users_table u166 USING (user_id) LEFT JOIN users_table u167 USING (user_id) LEFT JOIN users_table u168 USING (user_id) LEFT JOIN users_table u169 USING (user_id) LEFT JOIN users_table u170 USING (user_id) LEFT JOIN users_table u171 USING (user_id) LEFT JOIN users_table u172 USING (user_id) LEFT JOIN users_table u173 USING (user_id) LEFT JOIN users_table u174 USING (user_id) LEFT JOIN users_table u175 USING (user_id) LEFT JOIN users_table u176 USING (user_id) LEFT JOIN users_table u177 USING (user_id) LEFT JOIN users_table u178 USING (user_id) LEFT JOIN users_table u179 USING (user_id) LEFT JOIN users_table u180 USING (user_id) LEFT JOIN users_table u181 USING (user_id) LEFT JOIN users_table u182 USING (user_id) LEFT JOIN users_table u183 USING (user_id) LEFT JOIN users_table u184 USING (user_id) LEFT JOIN users_table u185 USING (user_id) LEFT JOIN users_table u186 USING (user_id) LEFT JOIN users_table u187 USING (user_id) LEFT JOIN users_table u188 USING (user_id) LEFT JOIN users_table u189 USING (user_id) LEFT JOIN users_table u190 USING (user_id) LEFT JOIN users_table u191 USING (user_id) LEFT JOIN users_table u192 USING (user_id) LEFT JOIN users_table u193 USING (user_id) LEFT JOIN users_table u194 USING (user_id) LEFT JOIN users_table u195 USING (user_id) LEFT JOIN users_table u196 USING (user_id) LEFT JOIN users_table u197 USING (user_id) LEFT JOIN users_table u198 USING (user_id) LEFT JOIN users_table u199 USING (user_id) LEFT JOIN users_table u200 USING (user_id) LEFT JOIN users_table u201 USING (user_id) LEFT JOIN users_table u202 USING (user_id) LEFT JOIN users_table u203 USING (user_id) LEFT JOIN users_table u204 USING (user_id) LEFT JOIN users_table u205 USING (user_id) LEFT JOIN users_table u206 USING (user_id) LEFT JOIN users_table u207 USING (user_id) LEFT JOIN users_table u208 USING (user_id) LEFT JOIN users_table u209 USING (user_id) LEFT JOIN users_table u210 USING (user_id) LEFT JOIN users_table u211 USING (user_id) LEFT JOIN users_table u212 USING (user_id) LEFT JOIN users_table u213 USING (user_id) LEFT JOIN users_table u214 USING (user_id) LEFT JOIN users_table u215 USING (user_id) LEFT JOIN users_table u216 USING (user_id) LEFT JOIN users_table u217 USING (user_id) LEFT JOIN users_table u218 USING (user_id) LEFT JOIN users_table u219 USING (user_id) LEFT JOIN users_table u220 USING (user_id) LEFT JOIN users_table u221 USING (user_id) LEFT JOIN users_table u222 USING (user_id) LEFT JOIN users_table u223 USING (user_id) LEFT JOIN users_table u224 USING (user_id) LEFT JOIN users_table u225 USING (user_id) LEFT JOIN users_table u226 USING (user_id) LEFT JOIN users_table u227 USING (user_id) LEFT JOIN users_table u228 USING (user_id) LEFT JOIN users_table u229 USING (user_id) LEFT JOIN users_table u230 USING (user_id) LEFT JOIN users_table u231 USING (user_id) LEFT JOIN users_table u232 USING (user_id) LEFT JOIN users_table u233 USING (user_id) LEFT JOIN users_table u234 USING (user_id) LEFT JOIN users_table u235 USING (user_id) LEFT JOIN users_table u236 USING (user_id) LEFT JOIN users_table u237 USING (user_id) LEFT JOIN users_table u238 USING (user_id) LEFT JOIN users_table u239 USING (user_id) LEFT JOIN users_table u240 USING (user_id) LEFT JOIN users_table u241 USING (user_id) LEFT JOIN users_table u242 USING (user_id) LEFT JOIN users_table u243 USING (user_id) LEFT JOIN users_table u244 USING (user_id) LEFT JOIN users_table u245 USING (user_id) LEFT JOIN users_table u246 USING (user_id) LEFT JOIN users_table u247 USING (user_id) LEFT JOIN users_table u248 USING (user_id) LEFT JOIN users_table u249 USING (user_id) LEFT JOIN users_table u250 USING (user_id) LEFT JOIN users_table u251 USING (user_id) LEFT JOIN users_table u252 USING (user_id) LEFT JOIN users_table u253 USING (user_id) LEFT JOIN users_table u254 USING (user_id) LEFT JOIN users_table u255 USING (user_id) LEFT JOIN users_table u256 USING (user_id) LEFT JOIN users_table u257 USING (user_id) LEFT JOIN users_table u258 USING (user_id) LEFT JOIN users_table u259 USING (user_id) LEFT JOIN users_table u260 USING (user_id) LEFT JOIN users_table u261 USING (user_id) LEFT JOIN users_table u262 USING (user_id) LEFT JOIN users_table u263 USING (user_id) LEFT JOIN users_table u264 USING (user_id) LEFT JOIN users_table u265 USING (user_id) LEFT JOIN users_table u266 USING (user_id) LEFT JOIN users_table u267 USING (user_id) LEFT JOIN users_table u268 USING (user_id) LEFT JOIN users_table u269 USING (user_id) LEFT JOIN users_table u270 USING (user_id) LEFT JOIN users_table u271 USING (user_id) LEFT JOIN users_table u272 USING (user_id) LEFT JOIN users_table u273 USING (user_id) LEFT JOIN users_table u274 USING (user_id) LEFT JOIN users_table u275 USING (user_id) LEFT JOIN users_table u276 USING (user_id) LEFT JOIN users_table u277 USING (user_id) LEFT JOIN users_table u278 USING (user_id) LEFT JOIN users_table u279 USING (user_id) LEFT JOIN users_table u280 USING (user_id) LEFT JOIN users_table u281 USING (user_id) LEFT JOIN users_table u282 USING (user_id) LEFT JOIN users_table u283 USING (user_id) LEFT JOIN users_table u284 USING (user_id) LEFT JOIN users_table u285 USING (user_id) LEFT JOIN users_table u286 USING (user_id) LEFT JOIN users_table u287 USING (user_id) LEFT JOIN users_table u288 USING (user_id) LEFT JOIN users_table u289 USING (user_id) LEFT JOIN users_table u290 USING (user_id) LEFT JOIN users_table u291 USING (user_id) LEFT JOIN users_table u292 USING (user_id) LEFT JOIN users_table u293 USING (user_id) LEFT JOIN users_table u294 USING (user_id) LEFT JOIN users_table u295 USING (user_id) LEFT JOIN users_table u296 USING (user_id) LEFT JOIN users_table u297 USING (user_id) LEFT JOIN users_table u298 USING (user_id) LEFT JOIN users_table u299 USING (user_id) LEFT JOIN users_table u300 USING (user_id) LEFT JOIN users_table u301 USING (user_id) LEFT JOIN users_table u302 USING (user_id) LEFT JOIN users_table u303 USING (user_id) LEFT JOIN users_table u304 USING (user_id) LEFT JOIN users_table u305 USING (user_id) LEFT JOIN users_table u306 USING (user_id) LEFT JOIN users_table u307 USING (user_id) LEFT JOIN users_table u308 USING (user_id) LEFT JOIN users_table u309 USING (user_id) LEFT JOIN users_table u310 USING (user_id) LEFT JOIN users_table u311 USING (user_id) LEFT JOIN users_table u312 USING (user_id) LEFT JOIN users_table u313 USING (user_id) LEFT JOIN users_table u314 USING (user_id) LEFT JOIN users_table u315 USING (user_id) LEFT JOIN users_table u316 USING (user_id) LEFT JOIN users_table u317 USING (user_id) LEFT JOIN users_table u318 USING (user_id) LEFT JOIN users_table u319 USING (user_id) LEFT JOIN users_table u320 USING (user_id) LEFT JOIN users_table u321 USING (user_id) LEFT JOIN users_table u322 USING (user_id) LEFT JOIN users_table u323 USING (user_id) LEFT JOIN users_table u324 USING (user_id) LEFT JOIN users_table u325 USING (user_id) LEFT JOIN users_table u326 USING (user_id) LEFT JOIN users_table u327 USING (user_id) LEFT JOIN users_table u328 USING (user_id) LEFT JOIN users_table u329 USING (user_id) LEFT JOIN users_table u330 USING (user_id) LEFT JOIN users_table u331 USING (user_id) LEFT JOIN users_table u332 USING (user_id) LEFT JOIN users_table u333 USING (user_id) LEFT JOIN users_table u334 USING (user_id) LEFT JOIN users_table u335 USING (user_id) LEFT JOIN users_table u336 USING (user_id) LEFT JOIN users_table u337 USING (user_id) LEFT JOIN users_table u338 USING (user_id) LEFT JOIN users_table u339 USING (user_id) LEFT JOIN users_table u340 USING (user_id) LEFT JOIN users_table u341 USING (user_id) LEFT JOIN users_table u342 USING (user_id) LEFT JOIN users_table u343 USING (user_id) LEFT JOIN users_table u344 USING (user_id) LEFT JOIN users_table u345 USING (user_id) LEFT JOIN users_table u346 USING (user_id) LEFT JOIN users_table u347 USING (user_id) LEFT JOIN users_table u348 USING (user_id) LEFT JOIN users_table u349 USING (user_id) LEFT JOIN users_table u350 USING (user_id) LEFT JOIN users_table u351 USING (user_id) LEFT JOIN users_table u352 USING (user_id) LEFT JOIN users_table u353 USING (user_id) LEFT JOIN users_table u354 USING (user_id) LEFT JOIN users_table u355 USING (user_id) LEFT JOIN users_table u356 USING (user_id) LEFT JOIN users_table u357 USING (user_id) LEFT JOIN users_table u358 USING (user_id) LEFT JOIN users_table u359 USING (user_id) LEFT JOIN users_table u360 USING (user_id) LEFT JOIN users_table u361 USING (user_id) LEFT JOIN users_table u362 USING (user_id) LEFT JOIN users_table u363 USING (user_id) LEFT JOIN users_table u364 USING (user_id) LEFT JOIN users_table u365 USING (user_id) LEFT JOIN users_table u366 USING (user_id) LEFT JOIN users_table u367 USING (user_id) LEFT JOIN users_table u368 USING (user_id) LEFT JOIN users_table u369 USING (user_id) LEFT JOIN users_table u370 USING (user_id) LEFT JOIN users_table u371 USING (user_id) LEFT JOIN users_table u372 USING (user_id) LEFT JOIN users_table u373 USING (user_id) LEFT JOIN users_table u374 USING (user_id) LEFT JOIN users_table u375 USING (user_id) LEFT JOIN users_table u376 USING (user_id) LEFT JOIN users_table u377 USING (user_id) LEFT JOIN users_table u378 USING (user_id) LEFT JOIN users_table u379 USING (user_id) LEFT JOIN users_table u380 USING (user_id) LEFT JOIN users_table u381 USING (user_id) LEFT JOIN users_table u382 USING (user_id) LEFT JOIN users_table u383 USING (user_id) LEFT JOIN users_table u384 USING (user_id) LEFT JOIN users_table u385 USING (user_id) LEFT JOIN users_table u386 USING (user_id) LEFT JOIN users_table u387 USING (user_id) LEFT JOIN users_table u388 USING (user_id) LEFT JOIN users_table u389 USING (user_id) LEFT JOIN users_table u390 USING (user_id) LEFT JOIN users_table u391 USING (user_id) LEFT JOIN users_table u392 USING (user_id) LEFT JOIN users_table u393 USING (user_id) LEFT JOIN users_table u394 USING (user_id) LEFT JOIN users_table u395 USING (user_id) LEFT JOIN users_table u396 USING (user_id) LEFT JOIN users_table u397 USING (user_id) LEFT JOIN users_table u398 USING (user_id) LEFT JOIN users_table u399 USING (user_id) LEFT JOIN users_table u400 USING (user_id) LEFT JOIN users_table u401 USING (user_id) LEFT JOIN users_table u402 USING (user_id) LEFT JOIN users_table u403 USING (user_id) LEFT JOIN users_table u404 USING (user_id) LEFT JOIN users_table u405 USING (user_id) LEFT JOIN users_table u406 USING (user_id) LEFT JOIN users_table u407 USING (user_id) LEFT JOIN users_table u408 USING (user_id) LEFT JOIN users_table u409 USING (user_id) LEFT JOIN users_table u410 USING (user_id) LEFT JOIN users_table u411 USING (user_id) LEFT JOIN users_table u412 USING (user_id) LEFT JOIN users_table u413 USING (user_id) LEFT JOIN users_table u414 USING (user_id) LEFT JOIN users_table u415 USING (user_id) LEFT JOIN users_table u416 USING (user_id) LEFT JOIN users_table u417 USING (user_id) LEFT JOIN users_table u418 USING (user_id) LEFT JOIN users_table u419 USING (user_id) LEFT JOIN users_table u420 USING (user_id) LEFT JOIN users_table u421 USING (user_id) LEFT JOIN users_table u422 USING (user_id) LEFT JOIN users_table u423 USING (user_id) LEFT JOIN users_table u424 USING (user_id) LEFT JOIN users_table u425 USING (user_id) LEFT JOIN users_table u426 USING (user_id) LEFT JOIN users_table u427 USING (user_id) LEFT JOIN users_table u428 USING (user_id) LEFT JOIN users_table u429 USING (user_id) LEFT JOIN users_table u430 USING (user_id) LEFT JOIN users_table u431 USING (user_id) LEFT JOIN users_table u432 USING (user_id) LEFT JOIN users_table u433 USING (user_id) LEFT JOIN users_table u434 USING (user_id) LEFT JOIN users_table u435 USING (user_id) LEFT JOIN users_table u436 USING (user_id) LEFT JOIN users_table u437 USING (user_id) LEFT JOIN users_table u438 USING (user_id) LEFT JOIN users_table u439 USING (user_id) LEFT JOIN users_table u440 USING (user_id) LEFT JOIN users_table u441 USING (user_id) LEFT JOIN users_table u442 USING (user_id) LEFT JOIN users_table u443 USING (user_id) LEFT JOIN users_table u444 USING (user_id) LEFT JOIN users_table u445 USING (user_id) LEFT JOIN users_table u446 USING (user_id) LEFT JOIN users_table u447 USING (user_id) LEFT JOIN users_table u448 USING (user_id) LEFT JOIN users_table u449 USING (user_id) LEFT JOIN users_table u450 USING (user_id) LEFT JOIN users_table u451 USING (user_id) LEFT JOIN users_table u452 USING (user_id) LEFT JOIN users_table u453 USING (user_id) LEFT JOIN users_table u454 USING (user_id) LEFT JOIN users_table u455 USING (user_id) LEFT JOIN users_table u456 USING (user_id) LEFT JOIN users_table u457 USING (user_id) LEFT JOIN users_table u458 USING (user_id) LEFT JOIN users_table u459 USING (user_id) LEFT JOIN users_table u460 USING (user_id) LEFT JOIN users_table u461 USING (user_id) LEFT JOIN users_table u462 USING (user_id) LEFT JOIN users_table u463 USING (user_id) LEFT JOIN users_table u464 USING (user_id) LEFT JOIN users_table u465 USING (user_id) LEFT JOIN users_table u466 USING (user_id) LEFT JOIN users_table u467 USING (user_id) LEFT JOIN users_table u468 USING (user_id) LEFT JOIN users_table u469 USING (user_id) LEFT JOIN users_table u470 USING (user_id) LEFT JOIN users_table u471 USING (user_id) LEFT JOIN users_table u472 USING (user_id) LEFT JOIN users_table u473 USING (user_id) LEFT JOIN users_table u474 USING (user_id) LEFT JOIN users_table u475 USING (user_id) LEFT JOIN users_table u476 USING (user_id) LEFT JOIN users_table u477 USING (user_id) LEFT JOIN users_table u478 USING (user_id) LEFT JOIN users_table u479 USING (user_id) LEFT JOIN users_table u480 USING (user_id) LEFT JOIN users_table u481 USING (user_id) LEFT JOIN users_table u482 USING (user_id) LEFT JOIN users_table u483 USING (user_id) LEFT JOIN users_table u484 USING (user_id) LEFT JOIN users_table u485 USING (user_id) LEFT JOIN users_table u486 USING (user_id) LEFT JOIN users_table u487 USING (user_id) LEFT JOIN users_table u488 USING (user_id) LEFT JOIN users_table u489 USING (user_id) LEFT JOIN users_table u490 USING (user_id) LEFT JOIN users_table u491 USING (user_id) LEFT JOIN users_table u492 USING (user_id) LEFT JOIN users_table u493 USING (user_id) LEFT JOIN users_table u494 USING (user_id) LEFT JOIN users_table u495 USING (user_id) LEFT JOIN users_table u496 USING (user_id) LEFT JOIN users_table u497 USING (user_id) LEFT JOIN users_table u498 USING (user_id) LEFT JOIN users_table u499 USING (user_id);
-- asserts enabled
(lldb) bt
* thread #1, queue = 'com.apple.main-thread', stop reason = signal SIGABRT
* frame #0: 0x00007fff639fa2c2 libsystem_kernel.dylib`__pthread_kill + 10
frame #1: 0x00007fff63ab5bf1 libsystem_pthread.dylib`pthread_kill + 284
frame #2: 0x00007fff639646a6 libsystem_c.dylib`abort + 127
frame #3: 0x0000000102180a02 postgres`ExceptionalCondition(conditionName=<unavailable>, errorType=<unavailable>, fileName=<unavailable>, lineNumber=<unavailable>) at assert.c:67:2
frame #4: 0x0000000101ece9b2 postgres`initial_cost_mergejoin(root=0x7ff0000000000000, workspace=0x00007ffeedf5b528, jointype=JOIN_INNER, mergeclauses=<unavailable>, outer_path=0x000000012ebf12d0, inner_path=0x4093d80000000000, outersortkeys=0x0000000000000000, innersortkeys=0x000000012ebf68e8, extra=0x00007ffeedf5b6f8) at costsize.c:3043:2
frame #5: 0x0000000101eda01b postgres`try_mergejoin_path(root=0x0000000104a12618, joinrel=0x000000012ebeede0, outer_path=0x000000012ebf12d0, inner_path=0x00000001283d00e8, pathkeys=0x000000012ebf67e0, mergeclauses=0x000000012ebf6890, outersortkeys=0x0000000000000000, innersortkeys=0x000000012ebf68e8, jointype=JOIN_LEFT, extra=0x00007ffeedf5b6f8, is_partial=<unavailable>) at joinpath.c:615:2
frame #6: 0x0000000101ed9426 postgres`sort_inner_and_outer(root=0x0000000104a12618, joinrel=0x000000012ebeede0, outerrel=<unavailable>, innerrel=<unavailable>, jointype=JOIN_LEFT, extra=0x00007ffeedf5b6f8) at joinpath.c:1038:3
frame #7: 0x0000000101ed8f7a postgres`add_paths_to_joinrel(root=0x0000000104a12618, joinrel=0x000000012ebeede0, outerrel=0x000000012ebe7b48, innerrel=0x0000000127f146e0, jointype=<unavailable>, sjinfo=<unavailable>, restrictlist=0x000000012ebf42b0) at joinpath.c:269:3
frame #8: 0x0000000101edbdc6 postgres`populate_joinrel_with_paths(root=0x0000000104a12618, rel1=0x000000012ebe7b48, rel2=0x0000000127f146e0, joinrel=0x000000012ebeede0, sjinfo=0x000000012809edc8, restrictlist=0x000000012ebf42b0) at joinrels.c:824:4
frame #9: 0x0000000101edb57a postgres`make_join_rel(root=0x0000000104a12618, rel1=0x000000012ebe7b48, rel2=0x0000000127f146e0) at joinrels.c:760:2
frame #10: 0x0000000101edb1ec postgres`make_rels_by_clause_joins(root=0x0000000104a12618, old_rel=0x000000012ebe7b48, other_rels_list=<unavailable>, other_rels=<unavailable>) at joinrels.c:312:11
frame #11: 0x0000000101edada3 postgres`join_search_one_level(root=0x0000000104a12618, level=2) at joinrels.c:123:4
frame #12: 0x0000000101ec7feb postgres`standard_join_search(root=0x0000000104a12618, levels_needed=8, initial_rels=0x000000012ebf4078) at allpaths.c:3097:3
frame #13: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001280a5618) at allpaths.c:2993:14
frame #14: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001280ab320) at allpaths.c:2993:14
frame #15: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001280b1028) at allpaths.c:2993:14
frame #16: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001280b6d30) at allpaths.c:2993:14
frame #17: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001280bca38) at allpaths.c:2993:14
frame #18: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001280c2740) at allpaths.c:2993:14
frame #19: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001280c8448) at allpaths.c:2993:14
frame #20: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001280ce150) at allpaths.c:2993:14
frame #21: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001280d3e58) at allpaths.c:2993:14
frame #22: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001280d9b60) at allpaths.c:2993:14
frame #23: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001280df868) at allpaths.c:2993:14
frame #24: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001280e5570) at allpaths.c:2993:14
frame #25: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001280eb278) at allpaths.c:2993:14
frame #26: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001280f0f80) at allpaths.c:2993:14
frame #27: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001280f8d88) at allpaths.c:2993:14
frame #28: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128101810) at allpaths.c:2993:14
frame #29: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x000000012810a298) at allpaths.c:2993:14
frame #30: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128112d20) at allpaths.c:2993:14
frame #31: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x000000012811b7a8) at allpaths.c:2993:14
frame #32: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128124230) at allpaths.c:2993:14
frame #33: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x000000012812ccb8) at allpaths.c:2993:14
frame #34: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128135740) at allpaths.c:2993:14
frame #35: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x000000012813e1c8) at allpaths.c:2993:14
frame #36: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128146c50) at allpaths.c:2993:14
frame #37: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x000000012814f6d8) at allpaths.c:2993:14
frame #38: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128158160) at allpaths.c:2993:14
frame #39: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128160be8) at allpaths.c:2993:14
frame #40: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128169670) at allpaths.c:2993:14
frame #41: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001281720f8) at allpaths.c:2993:14
frame #42: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x000000012817ab80) at allpaths.c:2993:14
frame #43: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128183608) at allpaths.c:2993:14
frame #44: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x000000012818c090) at allpaths.c:2993:14
frame #45: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128194b18) at allpaths.c:2993:14
frame #46: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x000000012819d5a0) at allpaths.c:2993:14
frame #47: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001281a6028) at allpaths.c:2993:14
frame #48: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001281aeab0) at allpaths.c:2993:14
frame #49: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001281b7538) at allpaths.c:2993:14
frame #50: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001281bffc0) at allpaths.c:2993:14
frame #51: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001281c8a48) at allpaths.c:2993:14
frame #52: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001281d14d0) at allpaths.c:2993:14
frame #53: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001281d9f58) at allpaths.c:2993:14
frame #54: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001281e29e0) at allpaths.c:2993:14
frame #55: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001281eb468) at allpaths.c:2993:14
frame #56: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001281f3ef0) at allpaths.c:2993:14
frame #57: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001281fc978) at allpaths.c:2993:14
frame #58: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128205400) at allpaths.c:2993:14
frame #59: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x000000012820de88) at allpaths.c:2993:14
frame #60: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128216910) at allpaths.c:2993:14
frame #61: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x000000012821f398) at allpaths.c:2993:14
frame #62: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128227e20) at allpaths.c:2993:14
frame #63: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001282308a8) at allpaths.c:2993:14
frame #64: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128239330) at allpaths.c:2993:14
frame #65: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128241db8) at allpaths.c:2993:14
frame #66: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x000000012824a840) at allpaths.c:2993:14
frame #67: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001282532c8) at allpaths.c:2993:14
frame #68: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x000000012825bd50) at allpaths.c:2993:14
frame #69: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001282647d8) at allpaths.c:2993:14
frame #70: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x000000012826d260) at allpaths.c:2993:14
frame #71: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128275ce8) at allpaths.c:2993:14
frame #72: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x000000012827e770) at allpaths.c:2993:14
frame #73: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001282871f8) at allpaths.c:2993:14
frame #74: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x000000012828fc80) at allpaths.c:2993:14
frame #75: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128298708) at allpaths.c:2993:14
frame #76: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001282a1190) at allpaths.c:2993:14
frame #77: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001282a9c18) at allpaths.c:2993:14
frame #78: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001282b26a0) at allpaths.c:2993:14
frame #79: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001282bb128) at allpaths.c:2993:14
frame #80: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001282c3bb0) at allpaths.c:2993:14
frame #81: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001282cc638) at allpaths.c:2993:14
frame #82: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001282d50c0) at allpaths.c:2993:14
frame #83: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001282ddb48) at allpaths.c:2993:14
frame #84: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001282e65d0) at allpaths.c:2993:14
frame #85: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001282ef058) at allpaths.c:2993:14
frame #86: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001282f7ae0) at allpaths.c:2993:14
frame #87: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128300568) at allpaths.c:2993:14
frame #88: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128308ff0) at allpaths.c:2993:14
frame #89: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128311a78) at allpaths.c:2993:14
frame #90: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x000000012831a500) at allpaths.c:2993:14
frame #91: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128322f88) at allpaths.c:2993:14
frame #92: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x000000012832ba10) at allpaths.c:2993:14
frame #93: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128334498) at allpaths.c:2993:14
frame #94: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x000000012833cf20) at allpaths.c:2993:14
frame #95: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001283459a8) at allpaths.c:2993:14
frame #96: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x000000012834e430) at allpaths.c:2993:14
frame #97: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x0000000128356eb8) at allpaths.c:2993:14
frame #98: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x000000012835f940) at allpaths.c:2993:14
frame #99: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x00000001283683c8) at allpaths.c:2993:14
frame #100: 0x0000000101ec6b38 postgres`make_rel_from_joinlist(root=0x0000000104a12618, joinlist=0x000000012837e358) at allpaths.c:2993:14
frame #101: 0x0000000101ec688f postgres`make_one_rel(root=0x0000000104a12618, joinlist=0x000000012837e358) at allpaths.c:227:8
frame #102: 0x0000000101eec187 postgres`query_planner(root=0x0000000104a12618, qp_callback=<unavailable>, qp_extra=0x00007ffeedf5d000) at planmain.c:269:14
frame #103: 0x0000000101eeea9b postgres`grouping_planner(root=0x0000000104a12618, inheritance_update=<unavailable>, tuple_fraction=<unavailable>) at planner.c:2058:17
frame #104: 0x0000000101eed1a1 postgres`subquery_planner(glob=<unavailable>, parse=0x00000001049ad620, parent_root=<unavailable>, hasRecursion=<unavailable>, tuple_fraction=0) at planner.c:1015:3
frame #105: 0x0000000101eec3b6 postgres`standard_planner(parse=0x00000001049ad620, query_string=<unavailable>, cursorOptions=256, boundParams=0x0000000000000000) at planner.c:405:9
frame #106: 0x0000000101faeaf1 postgres`pg_plan_query(querytree=0x00000001049ad620, query_string="SELECT count(*) FROM users_table u_1123123123123123 LEFT JOIN users_table u0 USING (user_id) LEFT JOIN users_table u1 USING (user_id) LEFT JOIN users_table u2 USING (user_id) LEFT JOIN users_table u3 USING (user_id) LEFT JOIN users_table u4 USING (user_id) LEFT JOIN users_table u5 USING (user_id) LEFT JOIN users_table u6 USING (user_id) LEFT JOIN users_table u7 USING (user_id) LEFT JOIN users_table u8 USING (user_id) LEFT JOIN users_table u9 USING (user_id) LEFT JOIN users_table u10 USING (user_id) LEFT JOIN users_table u11 USING (user_id) LEFT JOIN users_table u12 USING (user_id) LEFT JOIN users_table u13 USING (user_id) LEFT JOIN users_table u14 USING (user_id) LEFT JOIN users_table u15 USING (user_id) LEFT JOIN users_table u16 USING (user_id) LEFT JOIN users_table u17 USING (user_id) LEFT JOIN users_table u18 USING (user_id) LEFT JOIN users_table u19 USING (user_id) LEFT JOIN users_table u20 USING (user_id) LEFT JOIN users_table u21 USING (user_id) LEFT JOIN users_table u22 USING (use"..., cursorOptions=256, boundParams=0x0000000000000000) at postgres.c:875:9
frame #107: 0x0000000101faec32 postgres`pg_plan_queries(querytrees=0x00000001275c20e0, query_string="SELECT count(*) FROM users_table u_1123123123123123 LEFT JOIN users_table u0 USING (user_id) LEFT JOIN users_table u1 USING (user_id) LEFT JOIN users_table u2 USING (user_id) LEFT JOIN users_table u3 USING (user_id) LEFT JOIN users_table u4 USING (user_id) LEFT JOIN users_table u5 USING (user_id) LEFT JOIN users_table u6 USING (user_id) LEFT JOIN users_table u7 USING (user_id) LEFT JOIN users_table u8 USING (user_id) LEFT JOIN users_table u9 USING (user_id) LEFT JOIN users_table u10 USING (user_id) LEFT JOIN users_table u11 USING (user_id) LEFT JOIN users_table u12 USING (user_id) LEFT JOIN users_table u13 USING (user_id) LEFT JOIN users_table u14 USING (user_id) LEFT JOIN users_table u15 USING (user_id) LEFT JOIN users_table u16 USING (user_id) LEFT JOIN users_table u17 USING (user_id) LEFT JOIN users_table u18 USING (user_id) LEFT JOIN users_table u19 USING (user_id) LEFT JOIN users_table u20 USING (user_id) LEFT JOIN users_table u21 USING (user_id) LEFT JOIN users_table u22 USING (use"..., cursorOptions=256, boundParams=0x0000000000000000) at postgres.c:966:11
frame #108: 0x0000000101fb09fa postgres`exec_simple_query(query_string="SELECT count(*) FROM users_table u_1123123123123123 LEFT JOIN users_table u0 USING (user_id) LEFT JOIN users_table u1 USING (user_id) LEFT JOIN users_table u2 USING (user_id) LEFT JOIN users_table u3 USING (user_id) LEFT JOIN users_table u4 USING (user_id) LEFT JOIN users_table u5 USING (user_id) LEFT JOIN users_table u6 USING (user_id) LEFT JOIN users_table u7 USING (user_id) LEFT JOIN users_table u8 USING (user_id) LEFT JOIN users_table u9 USING (user_id) LEFT JOIN users_table u10 USING (user_id) LEFT JOIN users_table u11 USING (user_id) LEFT JOIN users_table u12 USING (user_id) LEFT JOIN users_table u13 USING (user_id) LEFT JOIN users_table u14 USING (user_id) LEFT JOIN users_table u15 USING (user_id) LEFT JOIN users_table u16 USING (user_id) LEFT JOIN users_table u17 USING (user_id) LEFT JOIN users_table u18 USING (user_id) LEFT JOIN users_table u19 USING (user_id) LEFT JOIN users_table u20 USING (user_id) LEFT JOIN users_table u21 USING (user_id) LEFT JOIN users_table u22 USING (use"...) at postgres.c:1158:19
frame #109: 0x0000000101fb024e postgres`PostgresMain(argc=<unavailable>, argv=<unavailable>, dbname=<unavailable>, username=<unavailable>) at postgres.c:0
frame #110: 0x0000000101f35f65 postgres`BackendRun(port=0x0000000000000001) at postmaster.c:4536:2
frame #111: 0x0000000101f35830 postgres`BackendStartup(port=<unavailable>) at postmaster.c:4220:3
frame #112: 0x0000000101f35005 postgres`ServerLoop at postmaster.c:1739:7
frame #113: 0x0000000101f3321c postgres`PostmasterMain(argc=3, argv=0x00007fc7a7403250) at postmaster.c:1412:11
frame #114: 0x0000000101e91e06 postgres`main(argc=3, argv=0x00007fc7a7403250) at main.c:210:3
frame #115: 0x00007fff638bf3d5 libdyld.dylib`start + 1
frame #116: 0x00007fff638bf3d5 libdyld.dylib`start + 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment