explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x2OB

Settings
# exclusive inclusive rows x rows loops node
1. 52.392 1,459.200 ↓ 1.0 46,302 1

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

2. 417.588 1,406.808 ↓ 1.0 46,302 1

Sort (cost=112,761.55..112,876.47 rows=45,970 width=1,365) (actual time=1,376.891..1,406.808 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.580 989.220 ↓ 1.0 46,302 1

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

4. 23.753 836.734 ↓ 1.0 46,302 1

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

5. 21.601 812.956 ↓ 1.0 46,302 1

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

6. 22.457 791.337 ↓ 1.0 46,302 1

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

7. 35.535 768.191 ↓ 1.0 46,302 1

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

8. 40.860 693.635 ↓ 1.0 46,302 1

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

9. 16.388 624.300 ↓ 1.0 46,302 1

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

10. 39.945 607.882 ↓ 1.0 46,302 1

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

11. 33.345 402.880 ↓ 1.0 46,302 1

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

12. 31.723 352.069 ↓ 1.0 46,302 1

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

13. 79.498 305.078 ↓ 1.0 46,302 1

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

14. 10.303 10.303 ↑ 1.0 95,108 1

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

15. 42.007 215.277 ↓ 1.0 46,302 1

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

16. 48.400 173.270 ↓ 1.0 46,302 1

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

17. 44.289 83.477 ↓ 1.0 46,302 1

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

18. 5.942 5.942 ↑ 1.0 38,595 1

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

19. 16.611 33.246 ↑ 1.0 45,970 1

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

20. 16.635 16.635 ↑ 1.0 45,970 1

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

21. 21.871 41.393 ↑ 1.0 44,813 1

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

22. 19.522 19.522 ↑ 1.0 44,813 1

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

23. 7.193 15.268 ↑ 1.0 40,927 1

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

24. 8.075 8.075 ↑ 1.0 40,927 1

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

25. 9.132 17.466 ↑ 1.0 40,906 1

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

26. 8.334 8.334 ↑ 1.0 40,906 1

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

27. 66.780 165.057 ↑ 1.0 209,385 1

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

28. 98.277 98.277 ↑ 1.0 209,385 1

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

29. 0.007 0.030 ↑ 1.0 8 1

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

30. 0.023 0.023 ↑ 1.0 8 1

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

31. 13.978 28.475 ↑ 1.0 54,573 1

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

32. 14.497 14.497 ↑ 1.0 54,573 1

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

33. 21.120 39.021 ↑ 1.0 95,108 1

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

34. 17.901 17.901 ↑ 1.0 95,108 1

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

35. 0.202 0.689 ↑ 1.0 1,268 1

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

36. 0.487 0.487 ↑ 1.0 1,268 1

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

37. 0.007 0.018 ↑ 1.0 8 1

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

38. 0.011 0.011 ↑ 1.0 8 1

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

39. 0.011 0.025 ↑ 1.0 36 1

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

40. 0.014 0.014 ↑ 1.0 36 1

Seq Scan on seriefacturacion serfac (cost=0..1.36 rows=36 width=102) (actual time=0.009..0.014 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.362 ms
Execution time : 1,470.313 ms