explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XCKA

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=527,922.840..527,922.850 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 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.000 0.000 ↓ 0.0

Aggregate (cost=527,922.720..527,922.730 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 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.000 0.000 ↓ 0.0

Seq Scan on foxtrot november (cost=0.000..192,437.410 rows=586,518 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=181,600.830..181,600.830 rows=717,721 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 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.000 0.000 ↓ 0.0

Seq Scan on uniform lima (cost=0.000..66,765.610 rows=717,721 width=8) (actual rows= loops=)