Created
October 8, 2020 11:09
-
-
Save onderkalaci/2b40a18d989da389ee4fb631e1ad7c0e to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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