explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oT6k

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 16.526 ↑ 3.0 2 1

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

2. 0.085 16.510 ↑ 1.2 5 1

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

3. 0.094 0.707 ↓ 29.0 58 1

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

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

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

5. 0.013 0.567 ↓ 38.0 38 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
6. 0.008 0.554 ↓ 38.0 38 1

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

7. 0.020 0.546 ↓ 38.0 38 1

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

8. 0.278 0.526 ↓ 38.0 38 1

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

  • Sort Key: parcuentascontables.fvccodigopuc, parcuentascontables.fvccuenta
  • Sort Method: quicksort Memory: 19kB
9. 0.248 0.248 ↓ 38.0 38 1

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

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

Index Scan using idxtblmovimientocontab8 on tblmovimientocontab m (cost=0.00..70.50 rows=7 width=32) (actual time=0.267..0.271 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 ((fvccodigopubcr)::text = (c. (...)
  • Filter: ((fvccodigopubdb)::text <> (fvccodigopubcr)::text)