explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uWhZM

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

Sort (cost=18,699.40..18,738.82 rows=15,770 width=30) (actual rows= loops=)

  • Sort Key: sd."Symbol
2. 0.000 0.000 ↓ 0.0

Finalize HashAggregate (cost=17,442.15..17,599.85 rows=15,770 width=30) (actual rows= loops=)

  • Group Key: sd."Symbol
3. 0.000 0.000 ↓ 0.0

Gather (cost=14,051.60..17,363.30 rows=31,540 width=30) (actual rows= loops=)

  • Workers Planned: 2
4. 0.000 0.000 ↓ 0.0

Partial HashAggregate (cost=13,051.60..13,209.30 rows=15,770 width=30) (actual rows= loops=)

  • Group Key: sd."Symbol
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=719.83..12,254.65 rows=318,780 width=30) (actual rows= loops=)

  • Hash Cond: ("Quotes"."Symbol" = sd."Symbol")
6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "Quotes" (cost=0.00..10,697.80 rows=318,780 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=522.70..522.70 rows=15,770 width=30) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on "StockDescription" sd (cost=0.00..522.70 rows=15,770 width=30) (actual rows= loops=)