explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MRSM

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 4,800.723 ↑ 5.0 5 1

Finalize GroupAggregate (cost=34,126.97..34,127.60 rows=25 width=18) (actual time=4,800.699..4,800.723 rows=5 loops=1)

  • Group Key: nom_pays
2. 0.062 4,800.694 ↑ 3.3 15 1

Sort (cost=34,126.97..34,127.10 rows=50 width=18) (actual time=4,800.688..4,800.694 rows=15 loops=1)

  • Sort Key: nom_pays
  • Sort Method: quicksort Memory: 17kB
3. 87.506 4,800.632 ↑ 3.3 15 1

Gather (cost=34,120.31..34,125.56 rows=50 width=18) (actual time=4,800.492..4,800.632 rows=15 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 91.525 4,713.126 ↑ 5.0 5 3

Partial HashAggregate (cost=33,120.31..33,120.56 rows=25 width=18) (actual time=4,713.120..4,713.126 rows=5 loops=3)

  • Group Key: nom_pays
5. 4,621.601 4,621.601 ↑ 1.3 51,577 3

Parallel Seq Scan on joseph_test_fournisseurs (cost=0.00..32,795.78 rows=64,906 width=22) (actual time=0.216..4,621.601 rows=51,577 loops=3)

  • Filter: (nom_region = 'Asie '::bpchar)
  • Rows Removed by Filter: 205817
Planning time : 92.925 ms
Execution time : 4,808.640 ms