explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 68TN

Settings
# exclusive inclusive rows x rows loops node
1. 198.154 1,471.463 ↓ 18.3 242,614 1

Gather (cost=98,292.76..105,454.99 rows=13,271 width=335) (actual time=946.930..1,471.463 rows=242,614 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 214.898 1,273.309 ↓ 14.6 48,523 5 / 5

Merge Join (cost=97,292.76..103,127.89 rows=3,318 width=335) (actual time=972.248..1,273.309 rows=48,523 loops=5)

  • Merge Cond: ((relacion_comer_localcliente.rco_nrutcliente = ped.ped_nrutcliente) AND (relacion_comer_localcliente.rco_nrutoperador = ped.ped_nrutoperador) AND (relacion_comer_localcliente.rco_nnumlocal = ped.ped_nnumlocal) AND ((relacion_comer_loca (...)
3. 269.080 318.354 ↑ 1.2 146,200 5 / 5

Sort (cost=50,112.05..50,568.68 rows=182,651 width=183) (actual time=288.987..318.354 rows=146,200 loops=5)

  • Sort Key: relacion_comer_localcliente.rco_nrutcliente, relacion_comer_localcliente.rco_nrutoperador, relacion_comer_localcliente.rco_nnumlocal, relacion_comer_localcliente.rco_scodrelacioncomercial
  • Sort Method: quicksort Memory: 46605kB
4. 49.274 49.274 ↑ 1.2 146,201 5 / 5

Parallel Seq Scan on relacion_comer_localcliente (cost=0.00..34,149.51 rows=182,651 width=183) (actual time=0.011..49.274 rows=146,201 loops=5)

5. 658.454 740.057 ↓ 1.0 283,195 5 / 5

Sort (cost=47,180.69..47,888.54 rows=283,143 width=152) (actual time=683.101..740.057 rows=283,195 loops=5)

  • Sort Key: ped.ped_nrutcliente, ped.ped_nrutoperador, ped.ped_nnumlocal, ped.ped_scodrelacioncomer
  • Sort Method: quicksort Memory: 83550kB
6. 81.603 81.603 ↓ 1.0 283,195 5 / 5

Seq Scan on pedido ped (cost=0.00..21,540.43 rows=283,143 width=152) (actual time=0.033..81.603 rows=283,195 loops=5)

Planning time : 1.448 ms
Execution time : 1,495.883 ms