explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2DBJ : d

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

Finalize GroupAggregate (cost=1,808,771.28..1,985,737.46 rows=367,927 width=12) (actual rows= loops=)

  • Group Key: authorid
2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=1,808,771.28..1,978,378.92 rows=735,854 width=12) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=1,807,771.26..1,892,443.08 rows=367,927 width=12) (actual rows= loops=)

  • Group Key: authorid
4. 0.000 0.000 ↓ 0.0

Sort (cost=1,807,771.26..1,834,768.78 rows=10,799,007 width=4) (actual rows= loops=)

  • Sort Key: authorid
5. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on paperbyauthors (cost=0.00..250,921.92 rows=10,799,007 width=4) (actual rows= loops=)

  • Filter: (paperid <> authorid)