explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T1UY

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

XN Aggregate (cost=131,986.44..131,986.44 rows=1 width=112) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

XN Subquery Scan volt_dt_0 (cost=131,978.59..131,984.87 rows=628 width=112) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

XN HashAggregate (cost=131,978.59..131,978.59 rows=628 width=40) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_NONE (cost=19,570.96..131,975.39 rows=1,278 width=40) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

XN Seq Scan on profile_fields2 (cost=0.00..79,204.91 rows=2,654,939 width=40) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

XN Hash (cost=19,569.39..19,569.39 rows=628 width=40) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

XN Seq Scan on events2 (cost=0.00..19,569.39 rows=628 width=40) (actual rows= loops=)