explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MqF

Settings
# exclusive inclusive rows x rows loops node
1. 0.058 360.148 ↑ 25.7 3 1

GroupAggregate (cost=17,358.08..17,359.62 rows=77 width=46) (actual time=360.132..360.148 rows=3 loops=1)

  • Group Key: ae.cod_alm_env
2. 0.025 360.090 ↑ 12.8 6 1

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

  • Sort Key: ae.cod_alm_env
  • Sort Method: quicksort Memory: 17kB
3. 9.322 360.065 ↑ 12.8 6 1

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

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

Seq Scan on almacen_envios ae (cost=0.00..17,283.56 rows=5,125 width=14) (actual time=0.217..350.615 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.128 ↓ 2.0 6 1

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

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

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

Planning time : 2.404 ms
Execution time : 360.230 ms