explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GulR

Settings

Optimization(s) for this plan:

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

CTE Scan on t (cost=41,767.80..42,967.80 rows=40,000 width=180) (actual rows= loops=)

2.          

CTE t
3. 0.000 0.000 ↓ 0.0
→

Sort (cost=41,667.80..41,767.80 rows=40,000 width=164) (actual rows= loops=)

  • Sort Key: ((dia.dia)::date)
4. 0.000 0.000 ↓ 0.0
→

HashAggregate (cost=37,510.26..38,610.26 rows=40,000 width=164) (actual rows= loops=)

  • Group Key: (dia.dia)::date, datos.canal, datos.tipo_venta_rsv
5. 0.000 0.000 ↓ 0.0
→

Nested Loop Left Join (cost=0.26..22,510.26 rows=1,000,000 width=164) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0
→

Function Scan on generate_series dia (cost=0.01..10.01 rows=1,000 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0
→

Function Scan on get_ventas_general_tmp datos (cost=0.26..10.26 rows=1,000 width=160) (actual rows= loops=)