explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dwQ9

Settings
# exclusive inclusive rows x rows loops node
1. 129.900 151.960 ↓ 1.0 208,953 1

Hash Right Join (cost=433.93..9,022.86 rows=205,639 width=395) (actual time=5.846..151.960 rows=208,953 loops=1)

  • Hash Cond: (mvcr.clientes_codigo = c.codigo)
2. 16.244 16.244 ↑ 1.0 205,639 1

Seq Scan on mvcontasareceber mvcr (cost=0.00..5,761.39 rows=205,639 width=117) (actual time=0.014..16.244 rows=205,639 loops=1)

3. 4.834 5.816 ↑ 1.0 8,708 1

Hash (cost=325.08..325.08 rows=8,708 width=278) (actual time=5.816..5.816 rows=8,708 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 2037kB
4. 0.982 0.982 ↑ 1.0 8,708 1

Seq Scan on clientes c (cost=0.00..325.08 rows=8,708 width=278) (actual time=0.002..0.982 rows=8,708 loops=1)