explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SJ6p

Settings
# exclusive inclusive rows x rows loops node
1. 1.027 3.234 ↓ 3.4 2,298 1

Nested Loop (cost=0.57..363.76 rows=682 width=197) (actual time=0.059..3.234 rows=2,298 loops=1)

2. 0.008 0.008 ↑ 1.0 1 1

Seq Scan on "TEMP_EXPLOITATIONS" te (cost=0.00..1.01 rows=1 width=54) (actual time=0.007..0.008 rows=1 loops=1)

3. 2.199 2.199 ↓ 3.4 2,298 1

Index Scan using "MOUVEMENT_BOVIN_COPACH_NUCHEP_idx" on "MOUVEMENT_BOVIN" mb (cost=0.57..355.93 rows=682 width=197) (actual time=0.047..2.199 rows=2,298 loops=1)

  • Index Cond: ((("COPACH")::text = (te."CODE_PAYS_EXPLOITATION")::text) AND (("NUCHEP")::text = (te."NUMERO_EXPLOITATION")::text))