explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IB7n

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

Append (cost=55,937,512.65..129,214,627.30 rows=58,085,788 width=68) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=55,937,512.65..64,316,884.71 rows=29,042,894 width=68) (actual rows= loops=)

  • Group Key: item.e_issn, item.publication, item.publisher_name
3. 0.000 0.000 ↓ 0.0

Gather Merge (cost=55,937,512.65..63,445,597.89 rows=58,085,788 width=68) (actual rows= loops=)

  • Workers Planned: 2
4. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=55,936,512.63..56,740,056.68 rows=29,042,894 width=68) (actual rows= loops=)

  • Group Key: item.e_issn, item.publication, item.publisher_name
5. 0.000 0.000 ↓ 0.0

Sort (cost=55,936,512.63..56,039,135.65 rows=41,049,209 width=60) (actual rows= loops=)

  • Sort Key: item.e_issn, item.publication, item.publisher_name
6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on item (cost=0.00..49,863,747.47 rows=41,049,209 width=60) (actual rows= loops=)

  • Filter: (length(btrim(e_issn)) > 0)
7. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=55,937,512.65..64,316,884.71 rows=29,042,894 width=68) (actual rows= loops=)

  • Group Key: item_1.p_issn, item_1.publication, item_1.publisher_name
8. 0.000 0.000 ↓ 0.0

Gather Merge (cost=55,937,512.65..63,445,597.89 rows=58,085,788 width=68) (actual rows= loops=)

  • Workers Planned: 2
9. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=55,936,512.63..56,740,056.68 rows=29,042,894 width=68) (actual rows= loops=)

  • Group Key: item_1.p_issn, item_1.publication, item_1.publisher_name
10. 0.000 0.000 ↓ 0.0

Sort (cost=55,936,512.63..56,039,135.65 rows=41,049,209 width=60) (actual rows= loops=)

  • Sort Key: item_1.p_issn, item_1.publication, item_1.publisher_name
11. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on item item_1 (cost=0.00..49,863,747.47 rows=41,049,209 width=60) (actual rows= loops=)

  • Filter: (length(btrim(p_issn)) > 0)