explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y2rf : Optimization for: plan #ir4f

Settings

Optimization path:

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

Nested Loop (cost=25.84..5,055,945.79 rows=112,600 width=10,471) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

ProjectSet (cost=25.29..4,864.45 rows=112,600 width=10,430) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on akto_estaciones_clientes_particulares (cost=25.29..4,293.00 rows=1,126 width=10,430) (actual rows= loops=)

  • Recheck Cond: (n_concesion = '19268'::numeric)
  • Filter: (distance < '50'::numeric)
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on akto_estaciones_clientes_part_cod_est_idx (cost=0.00..25.01 rows=1,145 width=0) (actual rows= loops=)

  • Index Cond: (n_concesion = '19268'::numeric)
5. 0.000 0.000 ↓ 0.0

Unique (cost=0.56..44.83 rows=1 width=41) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using _trans_cpart_id_socio_idx on akto_transacciones_clientes_particulares t (cost=0.56..44.83 rows=1 width=41) (actual rows= loops=)

  • Index Cond: ((unnest(akto_estaciones_clientes_particulares.id_socios)) = id_socio)
  • Filter: ((fecha >= '2019-01-01'::date) AND (fecha <= '2019-12-31'::date) AND (n_concesion = 19268) AND (descripcion = 'GASOLEO A'::text))