#	rows x	node
1.	↓ 0.0	→ Hash Join (cost=3026.740..9083.100 rows=72162 width=38) (actual time=.. rows= loops=) Hash Cond: (quebec_sierra.quebec_seven = alpha_seven.foxtrot)
2.	↓ 0.0	→ Seq Scan on delta quebec_sierra (cost=0.000..2678.570 rows=102557 width=38) (actual time=.. rows= loops=)
3.	↓ 0.0	→ Hash (cost=1840.160..1840.160 rows=72286 width=8) (actual time=.. rows= loops=)
4.	↓ 0.0	→ Seq Scan on echo alpha_seven (cost=0.000..1840.160 rows=72286 width=8) (actual time=.. rows= loops=) Filter: (alpha_india = 1)

Hash Join  (cost=3026.740..9083.100 rows=72162 width=38)
    Hash Cond: (quebec_sierra.quebec_seven = alpha_seven.foxtrot)
  ->  Seq Scan on delta quebec_sierra  (cost=0.000..2678.570 rows=102557 width=38)
  ->  Hash  (cost=1840.160..1840.160 rows=72286 width=8)
        ->  Seq Scan on echo alpha_seven  (cost=0.000..1840.160 rows=72286 width=8)
                Filter: (alpha_india = 1)

Per node type stats

node type	count	sum of times	% of query
Hash	1	0.000 ms	0.0 %
Hash Join	1	0.000 ms	0.0 %
Seq Scan	2	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
delta	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
echo	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: tOg

Colorize:

Columns visibility:

Per node type stats

Per table stats