explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3eHW

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 31.743 ↓ 0.0 0 1

Nested Loop (cost=0.85..684.75 rows=1,285 width=197) (actual time=31.743..31.743 rows=0 loops=1)

2. 31.720 31.720 ↑ 1.0 1 1

Index Only Scan using "TEMP_EXPLOITATIONS_CODE_PAYS_EXPLOITATION_NUMERO_EXPLOITATI_idx" on "TEMP_EXPLOITATIONS" te (cost=0.28..2.50 rows=1 width=12) (actual time=31.720..31.720 rows=1 loops=1)

  • Index Cond: (("CODE_PAYS_EXPLOITATION" = 'FR'::text) AND ("NUMERO_EXPLOITATION" = '53001002'::text))
  • Heap Fetches: 1
3. 0.021 0.021 ↓ 0.0 0 1

Index Scan using "MOUVEMENT_BOVIN_COPACH_NUCHEP_idx" on "MOUVEMENT_BOVIN" mb (cost=0.57..669.40 rows=1,285 width=197) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: ((("COPACH")::text = 'FR'::text) AND (("NUCHEP")::text = '53001002'::text))