#	rows x	node
1.	↓ 0.0	→ Merge Join (cost=10956.420..172126959.060 rows=30000156 width=327) (actual time=.. rows= loops=) Merge Cond: (seven.alpha = uniform_sierra2.echo_two)
2.	↓ 0.0	→ Index Scan using echo_lima on seven (cost=0.000..20842438.280 rows=30002906 width=323) (actual time=.. rows= loops=)
3.	↓ 0.0	→ Index Scan using uniform_three on uniform_kilo (cost=0.000..61314267.530 rows=30000156 width=8) (actual time=.. rows= loops=) Index Cond: ((uniform_sierra2.oscar = 1) AND (uniform_sierra2.three = 1) AND (uniform_sierra2.whiskey = 1))

Merge Join  (cost=10956.420..172126959.060 rows=30000156 width=327)
    Merge Cond: (seven.alpha = uniform_sierra2.echo_two)
  ->  Index Scan using echo_lima on seven  (cost=0.000..20842438.280 rows=30002906 width=323)
  ->  Index Scan using uniform_three on uniform_kilo  (cost=0.000..61314267.530 rows=30000156 width=8)
          Index Cond: ((uniform_sierra2.oscar = 1) AND (uniform_sierra2.three = 1) AND (uniform_sierra2.whiskey = 1))

Per node type stats

node type	count	sum of times	% of query
Index Scan	2	0.000 ms	0.0 %
Merge Join	1	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
seven	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
uniform_kilo	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 1pw

Colorize:

Columns visibility:

Per node type stats

Per table stats