explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BxpM

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 1,178.563 ↑ 1.0 50 1

Limit (cost=236,500.53..281,610.42 rows=50 width=611) (actual time=1,177.844..1,178.563 rows=50 loops=1)

2. 0.026 1,178.559 ↑ 4.0 50 1

Unique (cost=236,500.53..416,940.09 rows=200 width=611) (actual time=1,177.843..1,178.559 rows=50 loops=1)

3. 0.535 1,178.533 ↑ 2,788.2 50 1

Nested Loop Left Join (cost=236,500.53..416,591.56 rows=139,411 width=611) (actual time=1,177.841..1,178.533 rows=50 loops=1)

4. 0.000 1,177.998 ↑ 2,788.2 50 1

Nested Loop Left Join (cost=236,500.39..359,048.48 rows=139,411 width=491) (actual time=1,177.646..1,177.998 rows=50 loops=1)

5. 0.022 1,177.950 ↑ 2,788.2 50 1

Nested Loop Left Join (cost=236,500.25..337,438.29 rows=139,411 width=413) (actual time=1,177.642..1,177.950 rows=50 loops=1)

6. 0.006 1,177.928 ↑ 2,788.2 50 1

Nested Loop Left Join (cost=236,500.10..314,397.08 rows=139,411 width=295) (actual time=1,177.640..1,177.928 rows=50 loops=1)

7. 0.032 1,177.872 ↑ 2,788.2 50 1

Merge Left Join (cost=236,499.95..291,391.75 rows=139,411 width=173) (actual time=1,177.632..1,177.872 rows=50 loops=1)

  • Merge Cond: ("*SELECT* 1".codigo = cr_fat.contasareceber_codigo)
8. 0.041 1,177.693 ↑ 2,788.2 50 1

Merge Left Join (cost=236,499.53..242,690.90 rows=139,411 width=161) (actual time=1,177.618..1,177.693 rows=50 loops=1)

  • Merge Cond: ("*SELECT* 1".codigo = cr_sit.contasareceber_codigo)
9. 51.642 982.784 ↑ 2,788.2 50 1

Sort (cost=132,906.21..133,254.74 rows=139,411 width=157) (actual time=982.774..982.784 rows=50 loops=1)

  • Sort Key: "*SELECT* 1".codigo
  • Sort Method: external merge Disk: 16264kB
10. 23.128 931.142 ↑ 1.2 117,970 1

Hash Left Join (cost=64,656.77..110,032.25 rows=139,411 width=157) (actual time=467.368..931.142 rows=117,970 loops=1)

  • Hash Cond: ("*SELECT* 1".vendedores_codigo = vend.codigo)
11. 6.758 907.995 ↑ 1.2 117,970 1

Append (cost=64,653.89..109,655.66 rows=139,411 width=148) (actual time=467.341..907.995 rows=117,970 loops=1)

12. 13.969 888.732 ↑ 1.2 117,956 1

Subquery Scan on *SELECT* 1 (cost=64,653.89..104,733.91 rows=139,022 width=148) (actual time=467.340..888.732 rows=117,956 loops=1)

13. 269.431 874.763 ↑ 1.2 117,956 1

Hash Join (cost=64,653.89..103,343.69 rows=139,022 width=148) (actual time=467.339..874.763 rows=117,956 loops=1)

  • Hash Cond: (cr.codigo = pvpg_cr.contasareceber_codigo)
14. 138.135 138.135 ↓ 1.0 820,043 1

Seq Scan on contasareceber cr (cost=0.00..16,848.42 rows=820,042 width=49) (actual time=0.018..138.135 rows=820,043 loops=1)

15. 25.364 467.197 ↑ 1.2 117,956 1

Hash (cost=61,558.11..61,558.11 rows=139,022 width=50) (actual time=467.197..467.197 rows=117,956 loops=1)

  • Buckets: 65536 Batches: 4 Memory Usage: 2753kB
16. 141.442 441.833 ↑ 1.2 117,956 1

Hash Join (cost=38,098.89..61,558.11 rows=139,022 width=50) (actual time=251.004..441.833 rows=117,956 loops=1)

  • Hash Cond: (pvpg_cr.prevendas_pagtos_codigo = pvpg.codigo)
17. 49.469 49.469 ↑ 1.0 820,000 1

Seq Scan on prevendas_pagtos_contasareceber pvpg_cr (cost=0.00..11,829.00 rows=820,000 width=8) (actual time=0.005..49.469 rows=820,000 loops=1)

18. 8.548 250.922 ↑ 2.3 37,682 1

Hash (cost=36,266.48..36,266.48 rows=86,033 width=46) (actual time=250.922..250.922 rows=37,682 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 1875kB
19. 81.027 242.374 ↑ 2.3 37,682 1

Hash Join (cost=20,503.66..36,266.48 rows=86,033 width=46) (actual time=118.251..242.374 rows=37,682 loops=1)

  • Hash Cond: (pvpg.codprevenda = pv.codigo)
20. 43.183 43.183 ↓ 1.0 507,455 1

Seq Scan on prevenda_pagto pvpg (cost=0.00..8,313.53 rows=507,453 width=8) (actual time=0.005..43.183 rows=507,455 loops=1)

21. 7.630 118.164 ↑ 2.4 34,092 1

Hash (cost=18,759.91..18,759.91 rows=81,900 width=42) (actual time=118.164..118.164 rows=34,092 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 1682kB
22. 49.721 110.534 ↑ 2.4 34,092 1

Hash Join (cost=1,176.76..18,759.91 rows=81,900 width=42) (actual time=12.534..110.534 rows=34,092 loops=1)

  • Hash Cond: (pv.codcliente = cli.codigo)
23. 48.292 48.292 ↑ 1.0 483,072 1

Seq Scan on prevendas pv (cost=0.00..16,314.72 rows=483,072 width=16) (actual time=0.007..48.292 rows=483,072 loops=1)

24. 0.331 12.521 ↑ 1.1 2,297 1

Hash (cost=1,145.78..1,145.78 rows=2,479 width=30) (actual time=12.521..12.521 rows=2,297 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 175kB
25. 12.190 12.190 ↑ 1.1 2,297 1

Seq Scan on clientes cli (cost=0.00..1,145.78 rows=2,479 width=30) (actual time=0.013..12.190 rows=2,297 loops=1)

  • Filter: ((nome)::text ~~* '%jose%'::text)
  • Rows Removed by Filter: 12325
26. 0.002 0.453 ↓ 1.7 10 1

Subquery Scan on *SELECT* 2 (cost=1.55..379.85 rows=6 width=148) (actual time=0.095..0.453 rows=10 loops=1)

27. 0.028 0.451 ↓ 1.7 10 1

Nested Loop (cost=1.55..379.79 rows=6 width=148) (actual time=0.094..0.451 rows=10 loops=1)

28. 0.000 0.393 ↓ 1.7 10 1

Nested Loop (cost=1.13..329.13 rows=6 width=50) (actual time=0.070..0.393 rows=10 loops=1)

29. 0.038 0.291 ↑ 1.0 35 1

Nested Loop (cost=0.84..317.95 rows=35 width=24) (actual time=0.059..0.291 rows=35 loops=1)

30. 0.053 0.183 ↑ 1.0 35 1

Nested Loop (cost=0.42..296.75 rows=35 width=12) (actual time=0.036..0.183 rows=35 loops=1)

31. 0.025 0.025 ↑ 1.0 35 1

Seq Scan on saidasnf_pagtos_contasareceber snfpg_cr (cost=0.00..1.35 rows=35 width=8) (actual time=0.007..0.025 rows=35 loops=1)

32. 0.105 0.105 ↑ 1.0 1 35

Index Scan using saidasnf_pagto_pkey on saidasnf_pagto snfpg (cost=0.42..8.44 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=35)

  • Index Cond: (codigo = snfpg_cr.saidasnf_pagtos_codigo)
33. 0.070 0.070 ↑ 1.0 1 35

Index Scan using saidasnf_codigo_index on saidasnf snf (cost=0.42..0.61 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=35)

  • Index Cond: (codigo = snfpg.codsaidasnf)
34. 0.105 0.105 ↓ 0.0 0 35

Index Scan using unq_clientes on clientes cli_1 (cost=0.29..0.32 rows=1 width=30) (actual time=0.003..0.003 rows=0 loops=35)

  • Index Cond: (codigo = snf.codcliente)
  • Filter: ((nome)::text ~~* '%jose%'::text)
  • Rows Removed by Filter: 1
35. 0.030 0.030 ↑ 1.0 1 10

Index Scan using contasareceber_pkey1 on contasareceber cr_1 (cost=0.42..8.44 rows=1 width=49) (actual time=0.003..0.003 rows=1 loops=10)

  • Index Cond: (codigo = snfpg_cr.contasareceber_codigo)
36. 0.001 12.052 ↑ 95.8 4 1

Subquery Scan on *SELECT* 3 (cost=1,243.79..3,844.85 rows=383 width=148) (actual time=12.042..12.052 rows=4 loops=1)

37. 0.002 12.051 ↑ 95.8 4 1

Nested Loop Left Join (cost=1,243.79..3,841.02 rows=383 width=148) (actual time=12.041..12.051 rows=4 loops=1)

38. 0.003 12.045 ↑ 86.5 4 1

Nested Loop (cost=1,243.64..3,773.88 rows=346 width=91) (actual time=12.037..12.045 rows=4 loops=1)

39. 0.009 12.030 ↑ 86.5 4 1

Hash Right Join (cost=1,243.21..1,265.26 rows=346 width=46) (actual time=12.027..12.030 rows=4 loops=1)

  • Hash Cond: (cat.contasareceber_avulsas_codigo = crav.codigo)
40. 0.003 0.003 ↑ 260.0 3 1

Seq Scan on contasareceber_avulsas_tecnicos cat (cost=0.00..17.80 rows=780 width=8) (actual time=0.002..0.003 rows=3 loops=1)

41. 0.001 12.018 ↑ 173.0 2 1

Hash (cost=1,238.89..1,238.89 rows=346 width=42) (actual time=12.018..12.018 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
42. 0.007 12.017 ↑ 173.0 2 1

Hash Right Join (cost=1,216.84..1,238.89 rows=346 width=42) (actual time=12.014..12.017 rows=2 loops=1)

  • Hash Cond: (cav.contasareceber_avulsas_codigo = crav.codigo)
43. 0.004 0.004 ↑ 86.7 9 1

Seq Scan on contasareceber_avulsas_vendedores cav (cost=0.00..17.80 rows=780 width=8) (actual time=0.004..0.004 rows=9 loops=1)

44. 0.001 12.006 ↑ 346.0 1 1

Hash (cost=1,212.52..1,212.52 rows=346 width=38) (actual time=12.006..12.006 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
45. 0.010 12.005 ↑ 346.0 1 1

Hash Join (cost=1,176.76..1,212.52 rows=346 width=38) (actual time=12.004..12.005 rows=1 loops=1)

  • Hash Cond: (crav.clientes_codigo = cli_2.codigo)
46. 0.019 0.019 ↑ 255.0 8 1

Seq Scan on contasareceber_avulsas crav (cost=0.00..30.40 rows=2,040 width=12) (actual time=0.018..0.019 rows=8 loops=1)

47. 0.338 11.976 ↑ 1.1 2,297 1

Hash (cost=1,145.78..1,145.78 rows=2,479 width=30) (actual time=11.976..11.976 rows=2,297 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 175kB
48. 11.638 11.638 ↑ 1.1 2,297 1

Seq Scan on clientes cli_2 (cost=0.00..1,145.78 rows=2,479 width=30) (actual time=0.023..11.638 rows=2,297 loops=1)

  • Filter: ((nome)::text ~~* '%jose%'::text)
  • Rows Removed by Filter: 12325
49. 0.012 0.012 ↑ 1.0 1 4

Index Scan using contasareceber_pkey1 on contasareceber cr_2 (cost=0.42..7.25 rows=1 width=49) (actual time=0.003..0.003 rows=1 loops=4)

  • Index Cond: (codigo = crav.contasareceber_codigo)
50. 0.004 0.004 ↓ 0.0 0 4

Index Scan using contasareceber_avulsas_contas_contasareceber_avulsas_codigo_key on contasareceber_avulsas_contasareceber_avulsas_lotes crav_lot (cost=0.15..0.19 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=4)

  • Index Cond: (crav.codigo = contasareceber_avulsas_codigo)
51. 0.005 0.019 ↑ 1.0 39 1

Hash (cost=2.39..2.39 rows=39 width=13) (actual time=0.019..0.019 rows=39 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
52. 0.014 0.014 ↑ 1.0 39 1

Seq Scan on vendedores vend (cost=0.00..2.39 rows=39 width=13) (actual time=0.008..0.014 rows=39 loops=1)

53. 147.280 194.868 ↑ 3,388.6 242 1

Sort (cost=103,593.32..105,643.42 rows=820,041 width=8) (actual time=194.839..194.868 rows=242 loops=1)

  • Sort Key: cr_sit.contasareceber_codigo
  • Sort Method: external merge Disk: 14536kB
54. 47.588 47.588 ↓ 1.0 820,043 1

Seq Scan on contasareceber_situacao cr_sit (cost=0.00..11,829.41 rows=820,041 width=8) (actual time=0.007..47.588 rows=820,043 loops=1)

55. 0.147 0.147 ↑ 3,388.5 242 1

Index Scan using contasareceber_faturamentos_pkey on contasareceber_faturamentos cr_fat (cost=0.42..44,908.20 rows=820,006 width=12) (actual time=0.012..0.147 rows=242 loops=1)

56. 0.050 0.050 ↑ 1.0 1 50

Index Scan using situacoescontas_pkey on situacoescontas sc (cost=0.15..0.17 rows=1 width=126) (actual time=0.001..0.001 rows=1 loops=50)

  • Index Cond: (cr_sit.situacoesconta_codigo = codigo)
57. 0.000 0.000 ↓ 0.0 0 50

Index Scan using gruposcontas_pkey on gruposcontas grct (cost=0.15..0.17 rows=1 width=122) (actual time=0.000..0.000 rows=0 loops=50)

  • Index Cond: (codigo = "*SELECT* 1".gruposcontas_codigo)
58. 0.050 0.050 ↑ 1.0 1 50

Index Scan using tipodocumento_pkey on tipodocumento t (cost=0.14..0.16 rows=1 width=82) (actual time=0.001..0.001 rows=1 loops=50)

  • Index Cond: (codigo = "*SELECT* 1".tipodocumento_codigo)
59. 0.000 0.000 ↓ 0.0 0 50

Index Scan using tecnicos_pkey on tecnicos tec (cost=0.14..0.16 rows=1 width=122) (actual time=0.000..0.000 rows=0 loops=50)

  • Index Cond: (codigo = "*SELECT* 1".tecnicos_codigo)
Planning time : 6.763 ms
Execution time : 1,183.455 ms