explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tEPu

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.021 32.747 ↓ 0.0 0 1

Insert on tt_capitalcomparacalificacion (cost=322.87..323.14 rows=12 width=67) (actual time=32.747..32.747 rows=0 loops=1)

2. 0.008 32.726 ↑ 6.0 2 1

HashAggregate (cost=322.87..323.02 rows=12 width=67) (actual time=32.725..32.726 rows=2 loops=1)

3. 0.002 32.718 ↑ 3.0 4 1

Append (cost=161.25..322.75 rows=12 width=67) (actual time=19.294..32.718 rows=4 loops=1)

4. 0.043 19.293 ↑ 3.0 2 1

HashAggregate (cost=161.25..161.31 rows=6 width=41) (actual time=19.293..19.293 rows=2 loops=1)

5. 0.110 19.250 ↓ 3.3 20 1

Nested Loop (cost=11.36..161.19 rows=6 width=41) (actual time=10.818..19.250 rows=20 loops=1)

6. 0.119 0.754 ↓ 29.0 58 1

Hash Semi Join (cost=11.36..20.01 rows=2 width=23) (actual time=0.607..0.754 rows=58 loops=1)

  • Hash Cond: ((c.fvccuenta)::text = ("ANY_subquery".cta_contable)::text)
7. 0.053 0.053 ↑ 1.0 366 1

Seq Scan on parcuentascontables c (cost=0.00..7.66 rows=366 width=23) (actual time=0.010..0.053 rows=366 loops=1)

8. 0.017 0.582 ↓ 38.0 38 1

Hash (cost=11.35..11.35 rows=1 width=9) (actual time=0.582..0.582 rows=38 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
9. 0.007 0.565 ↓ 38.0 38 1

Subquery Scan on ANY_subquery (cost=11.33..11.35 rows=1 width=9) (actual time=0.538..0.565 rows=38 loops=1)

10. 0.020 0.558 ↓ 38.0 38 1

Group (cost=11.33..11.34 rows=1 width=23) (actual time=0.536..0.558 rows=38 loops=1)

11. 0.285 0.538 ↓ 38.0 38 1

Sort (cost=11.33..11.34 rows=1 width=23) (actual time=0.533..0.538 rows=38 loops=1)

  • Sort Key: colocaciones.parcuentascontables.fvccodigopuc, colocaciones.parcuentascontables.fvccuenta
  • Sort Method: quicksort Memory: 19kB
12. 0.253 0.253 ↓ 38.0 38 1

Seq Scan on parcuentascontables (cost=0.00..11.32 rows=1 width=23) (actual time=0.023..0.253 rows=38 loops=1)

  • Filter: (("substring"((fvccodigopuc)::text, 4, 1) = ANY ('{1,2}'::text[])) AND ("substring"((fvccodigopuc)::text, 1, 3) = '228'::text))
13. 18.386 18.386 ↓ 0.0 0 58

Index Scan using idxtblmovimientocontab7 on tblmovimientocontab m (cost=0.00..70.50 rows=7 width=32) (actual time=0.310..0.317 rows=0 loops=58)

  • Index Cond: (((fvcnumerocuenta)::text = '01150002176'::text) AND (fdtfechamovim >= '1999-01-01 00:00:00'::timestamp without time zone) AND (fdtfechamovim <= '2019-04-29 00:00:00'::timestamp without time zone) AND ((fvccodigo (...)
  • Filter: ((fvccodigopubdb)::text <> (fvccodigopubcr)::text)
14. 0.012 13.423 ↑ 3.0 2 1

HashAggregate (cost=161.25..161.32 rows=6 width=41) (actual time=13.422..13.423 rows=2 loops=1)

15. 0.027 13.411 ↑ 1.2 5 1

Nested Loop (cost=11.36..161.19 rows=6 width=41) (actual time=5.313..13.411 rows=5 loops=1)

16. 0.078 0.392 ↓ 29.0 58 1

Hash Semi Join (cost=11.36..20.01 rows=2 width=23) (actual time=0.301..0.392 rows=58 loops=1)

  • Hash Cond: ((c.fvccuenta)::text = ("ANY_subquery".cta_contable)::text)
17. 0.032 0.032 ↑ 1.0 366 1

Seq Scan on parcuentascontables c (cost=0.00..7.66 rows=366 width=23) (actual time=0.003..0.032 rows=366 loops=1)

18. 0.008 0.282 ↓ 38.0 38 1

Hash (cost=11.35..11.35 rows=1 width=9) (actual time=0.282..0.282 rows=38 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
19. 0.004 0.274 ↓ 38.0 38 1

Subquery Scan on ANY_subquery (cost=11.33..11.35 rows=1 width=9) (actual time=0.261..0.274 rows=38 loops=1)

20. 0.009 0.270 ↓ 38.0 38 1

Group (cost=11.33..11.34 rows=1 width=23) (actual time=0.260..0.270 rows=38 loops=1)

21. 0.137 0.261 ↓ 38.0 38 1

Sort (cost=11.33..11.34 rows=1 width=23) (actual time=0.259..0.261 rows=38 loops=1)

  • Sort Key: colocaciones.parcuentascontables.fvccodigopuc, colocaciones.parcuentascontables.fvccuenta
  • Sort Method: quicksort Memory: 19kB
22. 0.124 0.124 ↓ 38.0 38 1

Seq Scan on parcuentascontables (cost=0.00..11.32 rows=1 width=23) (actual time=0.013..0.124 rows=38 loops=1)

  • Filter: (("substring"((fvccodigopuc)::text, 4, 1) = ANY ('{1,2}'::text[])) AND ("substring"((fvccodigopuc)::text, 1, 3) = '228'::text))
23. 12.992 12.992 ↓ 0.0 0 58

Index Scan using idxtblmovimientocontab8 on tblmovimientocontab m (cost=0.00..70.50 rows=7 width=32) (actual time=0.219..0.224 rows=0 loops=58)

  • Index Cond: (((fvcnumerocuenta)::text = '01150002176'::text) AND (fdtfechamovim >= '1999-01-01 00:00:00'::timestamp without time zone) AND (fdtfechamovim <= '2019-04-29 00:00:00'::timestamp without time zone) AND ((fvccodigo (...)
  • Filter: ((fvccodigopubdb)::text <> (fvccodigopubcr)::text)