explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LIDL

Settings
# exclusive inclusive rows x rows loops node
1. 842.280 115,020.617 ↓ 0.0 0 1

Update on ent_vente_tmp (cost=336.81..143,553,456.29 rows=65,597 width=3,779) (actual time=115,020.617..115,020.617 rows=0 loops=1)

2. 30.700 114,178.337 ↑ 6.6 10,000 1

Hash Join (cost=336.81..143,553,456.29 rows=65,597 width=3,779) (actual time=233.307..114,178.337 rows=10,000 loops=1)

  • Hash Cond: ((ent_vente_tmp.vce_etablissement)::text = (magasin.mag_code_cbr__c)::text)
3. 42.729 42.729 ↑ 6.6 10,000 1

Seq Scan on ent_vente_tmp (cost=0.00..2,282.79 rows=65,597 width=3,629) (actual time=19.735..42.729 rows=10,000 loops=1)

4. 0.529 4.908 ↑ 1.0 1,201 1

Hash (cost=332.60..332.60 rows=1,201 width=21) (actual time=4.908..4.908 rows=1,201 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 82kB
5. 4.379 4.379 ↑ 1.0 1,201 1

Seq Scan on magasin__c magasin (cost=0.00..332.60 rows=1,201 width=21) (actual time=0.036..4.379 rows=1,201 loops=1)

6.          

SubPlan (forHash Join)

7. 0.000 114,100.000 ↓ 0.0 0 10,000

Limit (cost=2,188.37..2,188.37 rows=1 width=32) (actual time=11.410..11.410 rows=0 loops=10,000)

8. 10.000 114,100.000 ↓ 0.0 0 10,000

Unique (cost=2,188.37..2,188.37 rows=1 width=32) (actual time=11.410..11.410 rows=0 loops=10,000)

9. 60.000 114,090.000 ↓ 0.0 0 10,000

Sort (cost=2,188.37..2,188.37 rows=1 width=32) (actual time=11.409..11.409 rows=0 loops=10,000)

  • Sort Key: (concat(((('C'::text || (det_vente_tmp.vcl_cde_souche)::text) || '_'::text) || (det_vente_tmp.vcl_cde_numero)::text)))
  • Sort Method: quicksort Memory: 25kB
10. 114,030.000 114,030.000 ↓ 0.0 0 10,000

Seq Scan on det_vente_tmp (cost=0.00..2,188.37 rows=1 width=32) (actual time=11.403..11.403 rows=0 loops=10,000)

  • Filter: ((vcl_cde_numero IS NOT NULL) AND ((ent_vente_tmp.vce_souche)::text = (vce_souche)::text) AND ((ent_vente_tmp.vce_numero)::text = (vce_numero)::text))
  • Rows Removed by Filter: 46196