explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DCI9

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 326.488 ↓ 3.0 3 1

Unique (cost=17,358.08..17,358.47 rows=1 width=24) (actual time=326.474..326.488 rows=3 loops=1)

2. 0.030 326.476 ↑ 12.8 6 1

Sort (cost=17,358.08..17,358.28 rows=77 width=24) (actual time=326.472..326.476 rows=6 loops=1)

  • Sort Key: tmp.cod_envio, tmp.fec_situacion DESC
  • Sort Method: quicksort Memory: 17kB
3. 7.422 326.446 ↑ 12.8 6 1

Hash Join (cost=0.87..17,355.67 rows=77 width=24) (actual time=219.119..326.446 rows=6 loops=1)

  • Hash Cond: (textin(int4out(ae.cod_alm_env)) = (tmp.cod_envio)::text)
4. 318.958 318.958 ↑ 1.0 5,119 1

Seq Scan on almacen_envios ae (cost=0.00..17,283.56 rows=5,125 width=4) (actual time=0.194..318.958 rows=5,119 loops=1)

  • Filter: ((cod_alm_ext = 300) AND ((flag_status)::text = 'E'::text))
  • Rows Removed by Filter: 509252
5. 0.011 0.066 ↓ 2.0 6 1

Hash (cost=0.83..0.83 rows=3 width=17) (actual time=0.065..0.066 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 5kB
6. 0.055 0.055 ↓ 2.0 6 1

Seq Scan on tmp_shipments_wh tmp (cost=0.00..0.83 rows=3 width=17) (actual time=0.049..0.055 rows=6 loops=1)

Planning time : 0.235 ms
Execution time : 326.572 ms