explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IgIl

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Gather (cost=1,023.13..218,607,413.79 rows=42,206,391 width=251) (actual rows= loops=)

  • Workers Planned: 1
2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=23.13..213,907,849.38 rows=24,827,289 width=251) (actual rows= loops=)

  • Join Filter: ((cgp.cliente_pk)::text ~~ ((int_clie_cgg.numero_contrato)::text || '%'::text))
3. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on int_clie_contrato_general_gasto int_clie_cgg (cost=22.58..3,259.27 rows=774 width=182) (actual rows= loops=)

  • Filter: ((procesado IS FALSE) AND (ambito = ANY ('{E,R,B}'::bpchar[])))
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ix_int_clie_contrato_general_gasto_procesado (cost=0.00..22.25 rows=2,235 width=0) (actual rows= loops=)

  • Index Cond: (procesado = false)
5. 0.000 0.000 ↓ 0.0

Index Only Scan using ux_contrato_general_practica_cliente_pk on contrato_general_practica cgp (cost=0.56..163,144.01 rows=6,419,223 width=37) (actual rows= loops=)