#	rows x	node
1.	↓ 0.0	→ Aggregate (cost=527,922.840..527,922.850 rows=1 width=8) (actual rows= loops=)
2.	↓ 0.0	→ Gather Motion 8:1 (slice2; segments: 8) (cost=527,922.720..527,922.820 rows=1 width=8) (actual rows= loops=)
3.	↓ 0.0	→ Aggregate (cost=527,922.720..527,922.730 rows=1 width=8) (actual rows= loops=)
4.	↓ 0.0	→ Hash Left Join (cost=253,372.840..516,192.370 rows=586,518 width=0) (actual rows= loops=) Hash Cond: november.quebec = lima.quebec
5.	↓ 0.0	→ Seq Scan on foxtrot november (cost=0.000..192,437.410 rows=586,518 width=8) (actual rows= loops=)
6.	↓ 0.0	→ Hash (cost=181,600.830..181,600.830 rows=717,721 width=8) (actual rows= loops=)
7.	↓ 0.0	→ Redistribute Motion 8:8 (slice1; segments: 8) (cost=0.000..181,600.830 rows=717,721 width=8) (actual rows= loops=) Hash Key: e.id
8.	↓ 0.0	→ Seq Scan on uniform lima (cost=0.000..66,765.610 rows=717,721 width=8) (actual rows= loops=)

Aggregate  (cost=527922.840..527922.850 rows=1 width=8)
  ->  Gather Motion 8:1  (slice2; segments: 8)  (cost=527922.720..527922.820 rows=1 width=8)
        ->  Aggregate  (cost=527922.720..527922.730 rows=1 width=8)
              ->  Hash Left Join  (cost=253372.840..516192.370 rows=586518 width=0)
                      Hash Cond: november.quebec = lima.quebec
                    ->  Seq Scan on foxtrot november  (cost=0.000..192437.410 rows=586518 width=8)
                    ->  Hash  (cost=181600.830..181600.830 rows=717721 width=8)
                          ->  Redistribute Motion 8:8  (slice1; segments: 8)  (cost=0.000..181600.830 rows=717721 width=8)
                                  Hash Key: e.id
                                ->  Seq Scan on uniform lima  (cost=0.000..66765.610 rows=717721 width=8)

Per node type stats

node type	count	sum of times	% of query
Aggregate	2	0.000 ms	0.0 %
Gather Motion 8:1 (slice2; segments: 8)	1	0.000 ms	0.0 %
Hash	1	0.000 ms	0.0 %
Hash Left Join	1	0.000 ms	0.0 %
Redistribute Motion 8:8 (slice1; segments: 8)	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
foxtrot	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
uniform	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XCKA

Color mode:

Visible columns:

Per node type stats

Per table stats