explain.depesz.com

PostgreSQL's explain analyze made readable

Result: McBR

Settings
# exclusive inclusive rows x rows loops node
1. 267.177 299.464 ↓ 0.0 0 1

Update on "order" (cost=0.11..5,661.74 rows=1,267 width=1,758) (actual time=299.464..299.464 rows=0 loops=1)

2. 7.672 32.287 ↑ 1.0 1,267 1

Nested Loop (cost=0.11..5,661.74 rows=1,267 width=1,758) (actual time=1.411..32.287 rows=1,267 loops=1)

3. 3.076 3.076 ↑ 1.0 1,267 1

Seq Scan on ent_vente_tmpp ent_vente (cost=0.00..443.80 rows=1,267 width=251) (actual time=1.344..3.076 rows=1,267 loops=1)

  • Filter: integre
4. 21.539 21.539 ↑ 1.0 1 1,267

Index Scan using hcu_idx_order_ach_numero_commande__c on "order" (cost=0.11..4.11 rows=1 width=922) (actual time=0.017..0.017 rows=1 loops=1,267)

  • Index Cond: ((ach_numero_commande__c)::text = (ent_vente.numero_commande)::text)