explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0VsE

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

Sort (cost=26,497.29..26,502.27 rows=1,990 width=40) (actual rows= loops=)

  • Sort Key: m.fdtfechamovim
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=9.02..26,388.25 rows=1,990 width=40) (actual rows= loops=)

  • Hash Cond: ((m.fvccodigopubdb)::text = (c.fvccodigopuc)::text)
3. 0.000 0.000 ↓ 0.0

Index Scan using idxtblmovimientocontab6 on tblmovimientocontab m (cost=0.43..25,444.54 rows=242,733 width=40) (actual rows= loops=)

  • Index Cond: ((fdtfechamovim >= '2019-07-01 00:00:00'::timestamp without time zone) AND (fdtfechamovim <= '2019-07-31 00:00:00'::timestamp without time zone))
  • Filter: ((fvccodigopubdb)::text <> (fvccodigopubcr)::text)
4. 0.000 0.000 ↓ 0.0

Hash (cost=8.55..8.55 rows=3 width=14) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on parcuentascontables c (cost=4.30..8.55 rows=3 width=14) (actual rows= loops=)

  • Recheck Cond: (((fvccuenta)::text >= '41020201'::text) AND ((fvccuenta)::text <= '41020201'::text))
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idxparcuentascontables2 (cost=0.00..4.30 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (((fvccuenta)::text >= '41020201'::text) AND ((fvccuenta)::text <= '41020201'::text))