explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PF9X

Settings
# exclusive inclusive rows x rows loops node
1. 49.463 1,524.592 ↓ 1.0 46,302 1

Unique (cost=112,761.55..116,783.92 rows=45,970 width=1,365) (actual time=1,448.651..1,524.592 rows=46,302 loops=1)

2. 454.349 1,475.129 ↓ 1.0 46,302 1

Sort (cost=112,761.55..112,876.47 rows=45,970 width=1,365) (actual time=1,448.649..1,475.129 rows=46,302 loops=1)

  • Sort Key: enttes.descripcionbusquedas, enttes.tipoentidadtesoreria, fcobropago.descripcion, movtes.fecha, movtes.conceptotesoreria, movtes.importe, docbase.numeroexpediente, docbase.numerodocumento, inggasbas.importependienteliquidacion, inggasbas.importetotal, fac.totaliva, fac.totalretencion, fac.totalsuplidos, fac.totalbaseexenta, fac.totalbaseimponible, fac.numerodocumentoidentificativo, client.nombrecompleto, inggasbas.numeradorinforme, ingsinfac.informeconceptoingresosinfactura, fac.conceptofacturacionparabasico, cobr.id, inggasbas.id, fac.numerofacturanormalizado, inggasbas.fecha, serfac.descripcion, serfac.codigo, inggasbas.tipoig, fac.proforma, inggasbas.idnotario, inggasbas.idempresa, inggasbas.importecondonado, inggasbas.idcentrocostevalor, asicob.idejercicio, asicrea.idejercicio
  • Sort Method: external merge Disk: 12,864kB
3. 13.771 1,020.780 ↓ 1.0 46,302 1

Nested Loop (cost=29,133.55..93,186.94 rows=45,970 width=1,365) (actual time=515.502..1,020.78 rows=46,302 loops=1)

4. 23.878 868.103 ↓ 1.0 46,302 1

Hash Join (cost=29,133.13..32,653.03 rows=45,970 width=1,346) (actual time=515.387..868.103 rows=46,302 loops=1)

5. 21.577 844.128 ↓ 1.0 46,302 1

Hash Join (cost=29,131.32..32,516.35 rows=45,970 width=1,260) (actual time=515.256..844.128 rows=46,302 loops=1)

6. 23.087 822.445 ↓ 1.0 46,302 1

Hash Join (cost=29,130.14..32,342.49 rows=45,970 width=752) (actual time=515.083..822.445 rows=46,302 loops=1)

7. 35.289 794.999 ↓ 1.0 46,302 1

Hash Join (cost=29,067.61..32,158.89 rows=45,970 width=735) (actual time=510.685..794.999 rows=46,302 loops=1)

8. 42.344 714.287 ↓ 1.0 46,302 1

Hash Join (cost=26,321.68..29,292.29 rows=45,970 width=735) (actual time=465.063..714.287 rows=46,302 loops=1)

9. 16.454 638.530 ↓ 1.0 46,302 1

Hash Join (cost=24,174.78..27,024.72 rows=45,970 width=697) (actual time=431.356..638.53 rows=46,302 loops=1)

10. 40.036 622.044 ↓ 1.0 46,302 1

Hash Join (cost=24,173.6..26,902.85 rows=45,970 width=181) (actual time=431.306..622.044 rows=46,302 loops=1)

11. 33.781 395.794 ↓ 1.0 46,302 1

Hash Join (cost=8,246.44..10,855.02 rows=45,970 width=165) (actual time=244.659..395.794 rows=46,302 loops=1)

12. 30.599 340.635 ↓ 1.0 46,302 1

Hash Join (cost=6,997.06..9,484.95 rows=45,970 width=157) (actual time=223.02..340.635 rows=46,302 loops=1)

13. 77.555 291.715 ↓ 1.0 46,302 1

Hash Join (cost=5,733.2..8,100.41 rows=45,970 width=149) (actual time=204.41..291.715 rows=46,302 loops=1)

14. 10.140 10.140 ↑ 1.0 95,108 1

Seq Scan on asientobase asicrea (cost=0..1,557.08 rows=95,108 width=16) (actual time=0.038..10.14 rows=95,108 loops=1)

15. 36.641 204.020 ↓ 1.0 46,302 1

Hash (cost=5,158.57..5,158.57 rows=45,970 width=149) (actual time=204.02..204.02 rows=46,302 loops=1)

16. 41.803 167.379 ↓ 1.0 46,302 1

Hash Join (cost=4,151.62..5,158.57 rows=45,970 width=149) (actual time=81.006..167.379 rows=46,302 loops=1)

17. 40.160 76.014 ↓ 1.0 46,302 1

Hash Join (cost=1,934.33..2,820.6 rows=45,970 width=72) (actual time=31.236..76.014 rows=46,302 loops=1)

18. 4.971 4.971 ↑ 1.0 38,595 1

Seq Scan on cobro cobr (cost=0..784.95 rows=38,595 width=16) (actual time=0.03..4.971 rows=38,595 loops=1)

19. 15.840 30.883 ↑ 1.0 45,970 1

Hash (cost=1,359.7..1,359.7 rows=45,970 width=64) (actual time=30.883..30.883 rows=45,970 loops=1)

20. 15.043 15.043 ↑ 1.0 45,970 1

Seq Scan on ingresogastobase inggasbas (cost=0..1,359.7 rows=45,970 width=64) (actual time=0.035..15.043 rows=45,970 loops=1)

21. 25.579 49.562 ↑ 1.0 44,813 1

Hash (cost=1,657.13..1,657.13 rows=44,813 width=85) (actual time=49.562..49.562 rows=44,813 loops=1)

22. 23.983 23.983 ↑ 1.0 44,813 1

Seq Scan on factura fac (cost=0..1,657.13 rows=44,813 width=85) (actual time=0.01..23.983 rows=44,813 loops=1)

23. 10.308 18.321 ↑ 1.0 40,927 1

Hash (cost=752.27..752.27 rows=40,927 width=16) (actual time=18.321..18.321 rows=40,927 loops=1)

24. 8.013 8.013 ↑ 1.0 40,927 1

Seq Scan on facturaingreso facing (cost=0..752.27 rows=40,927 width=16) (actual time=0.031..8.013 rows=40,927 loops=1)

25. 11.732 21.378 ↑ 1.0 40,906 1

Hash (cost=738.06..738.06 rows=40,906 width=16) (actual time=21.378..21.378 rows=40,906 loops=1)

26. 9.646 9.646 ↑ 1.0 40,906 1

Seq Scan on facturaservicios facser (cost=0..738.06 rows=40,906 width=16) (actual time=0.024..9.646 rows=40,906 loops=1)

27. 79.001 186.214 ↑ 1.0 209,385 1

Hash (cost=13,309.85..13,309.85 rows=209,385 width=32) (actual time=186.214..186.214 rows=209,385 loops=1)

28. 107.213 107.213 ↑ 1.0 209,385 1

Seq Scan on documentobase docbase (cost=0..13,309.85 rows=209,385 width=32) (actual time=0.036..107.213 rows=209,385 loops=1)

29. 0.008 0.032 ↑ 1.0 8 1

Hash (cost=1.08..1.08 rows=8 width=524) (actual time=0.032..0.032 rows=8 loops=1)

30. 0.024 0.024 ↑ 1.0 8 1

Seq Scan on ingresosinfactura ingsinfac (cost=0..1.08 rows=8 width=524) (actual time=0.023..0.024 rows=8 loops=1)

31. 18.456 33.413 ↑ 1.0 54,573 1

Hash (cost=1,464.73..1,464.73 rows=54,573 width=46) (actual time=33.413..33.413 rows=54,573 loops=1)

32. 14.957 14.957 ↑ 1.0 54,573 1

Seq Scan on movimientotesoreria movtes (cost=0..1,464.73 rows=54,573 width=46) (actual time=0.016..14.957 rows=54,573 loops=1)

33. 27.261 45.423 ↑ 1.0 95,108 1

Hash (cost=1,557.08..1,557.08 rows=95,108 width=16) (actual time=45.422..45.423 rows=95,108 loops=1)

34. 18.162 18.162 ↑ 1.0 95,108 1

Seq Scan on asientobase asicob (cost=0..1,557.08 rows=95,108 width=16) (actual time=0.022..18.162 rows=95,108 loops=1)

35. 2.400 4.359 ↑ 1.0 1,268 1

Hash (cost=46.68..46.68 rows=1,268 width=33) (actual time=4.359..4.359 rows=1,268 loops=1)

36. 1.959 1.959 ↑ 1.0 1,268 1

Seq Scan on entidadtesoreria enttes (cost=0..46.68 rows=1,268 width=33) (actual time=0.04..1.959 rows=1,268 loops=1)

37. 0.034 0.106 ↑ 1.0 8 1

Hash (cost=1.08..1.08 rows=8 width=524) (actual time=0.106..0.106 rows=8 loops=1)

38. 0.072 0.072 ↑ 1.0 8 1

Seq Scan on formacobropago fcobropago (cost=0..1.08 rows=8 width=524) (actual time=0.065..0.072 rows=8 loops=1)

39. 0.041 0.097 ↑ 1.0 36 1

Hash (cost=1.36..1.36 rows=36 width=102) (actual time=0.097..0.097 rows=36 loops=1)

40. 0.056 0.056 ↑ 1.0 36 1

Seq Scan on seriefacturacion serfac (cost=0..1.36 rows=36 width=102) (actual time=0.041..0.056 rows=36 loops=1)

41. 138.906 138.906 ↑ 1.0 1 46,302

Index Scan using sujeto_pkey on sujeto client (cost=0.43..1.32 rows=1 width=35) (actual time=0.003..0.003 rows=1 loops=46,302)

  • Index Cond: (facing.idcliente = id)
Planning time : 6.268 ms
Execution time : 1,535.511 ms