explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6YaQ1

Settings
# exclusive inclusive rows x rows loops node
1. 1,786.867 12,311.349 ↓ 58.7 1,327,848 1

Sort (cost=71,276.08..71,332.62 rows=22,614 width=203) (actual time=12,236.109..12,311.349 rows=1,327,848 loops=1)

  • Sort Key: vz.code
  • Sort Method: quicksort Memory: 278078kB
2. 193.299 10,524.482 ↓ 58.7 1,327,848 1

Merge Left Join (cost=1,141.92..69,640.54 rows=22,614 width=203) (actual time=8,179.314..10,524.482 rows=1,327,848 loops=1)

  • Merge Cond: (vz.id = a95.id)
3. 198.178 10,123.157 ↓ 58.7 1,327,848 1

Merge Left Join (cost=1,081.85..69,518.55 rows=22,614 width=199) (actual time=7,972.367..10,123.157 rows=1,327,848 loops=1)

  • Merge Cond: (vz.id = a94.id)
4. 213.478 9,704.433 ↓ 58.7 1,327,848 1

Merge Left Join (cost=1,021.77..69,396.57 rows=22,614 width=191) (actual time=7,760.194..9,704.433 rows=1,327,848 loops=1)

  • Merge Cond: (vz.id = a69.id)
5. 206.801 9,246.938 ↓ 58.7 1,327,848 1

Merge Left Join (cost=961.69..69,274.58 rows=22,614 width=183) (actual time=7,538.537..9,246.938 rows=1,327,848 loops=1)

  • Merge Cond: (vz.id = a97.id)
6. 188.917 8,812.906 ↓ 58.7 1,327,848 1

Merge Left Join (cost=901.61..69,152.60 rows=22,614 width=175) (actual time=7,322.650..8,812.906 rows=1,327,848 loops=1)

  • Merge Cond: (vz.id = a59.id)
7. 200.310 8,400.659 ↓ 58.7 1,327,848 1

Merge Left Join (cost=841.53..69,030.62 rows=22,614 width=167) (actual time=7,110.791..8,400.659 rows=1,327,848 loops=1)

  • Merge Cond: (vz.id = a96.id)
8. 202.643 7,940.098 ↓ 58.7 1,327,848 1

Merge Left Join (cost=781.45..68,908.63 rows=22,614 width=159) (actual time=6,887.038..7,940.098 rows=1,327,848 loops=1)

  • Merge Cond: (vz.id = a58.id)
9. 232.481 7,475.644 ↓ 58.7 1,327,848 1

Merge Left Join (cost=721.37..68,786.65 rows=22,614 width=151) (actual time=6,662.745..7,475.644 rows=1,327,848 loops=1)

  • Merge Cond: (vz.id = a70.id)
10. 162.928 6,937.657 ↓ 58.7 1,327,848 1

Merge Left Join (cost=661.29..68,664.66 rows=22,614 width=143) (actual time=6,415.698..6,937.657 rows=1,327,848 loops=1)

  • Merge Cond: (vz.id = a93.id)
11. 185.963 6,558.939 ↓ 58.7 1,327,848 1

Merge Left Join (cost=601.21..68,542.68 rows=22,614 width=135) (actual time=6,201.059..6,558.939 rows=1,327,848 loops=1)

  • Merge Cond: (vz.id = a67.id)
12. 3.392 2,165.121 ↑ 1.0 21,768 1

Merge Left Join (cost=541.14..68,420.70 rows=22,614 width=127) (actual time=2,095.473..2,165.121 rows=21,768 loops=1)

  • Merge Cond: (vz.id = a62.id)
13. 3.910 1,945.749 ↑ 1.0 21,768 1

Merge Left Join (cost=481.06..68,298.71 rows=22,614 width=119) (actual time=1,879.581..1,945.749 rows=21,768 loops=1)

  • Merge Cond: (vz.id = a92.id)
14. 6.716 1,727.410 ↑ 1.0 21,768 1

Merge Left Join (cost=420.98..68,176.73 rows=22,614 width=111) (actual time=1,665.572..1,727.410 rows=21,768 loops=1)

  • Merge Cond: (vz.id = a64.id)
15. 3.523 1,081.162 ↑ 1.0 21,768 1

Merge Left Join (cost=360.90..68,054.74 rows=22,614 width=79) (actual time=1,030.166..1,081.162 rows=21,768 loops=1)

  • Merge Cond: (vz.id = a61.id)
16. 3.177 860.151 ↑ 1.0 21,768 1

Merge Left Join (cost=300.82..67,932.76 rows=22,614 width=71) (actual time=813.140..860.151 rows=21,768 loops=1)

  • Merge Cond: (vz.id = a53.id)
17. 4.018 827.961 ↑ 1.0 21,768 1

Merge Left Join (cost=240.74..67,810.78 rows=22,614 width=63) (actual time=784.187..827.961 rows=21,768 loops=1)

  • Merge Cond: (vz.id = a60.id)
18. 5.282 590.686 ↑ 1.0 21,768 1

Merge Left Join (cost=180.66..67,688.79 rows=22,614 width=55) (actual time=552.388..590.686 rows=21,768 loops=1)

  • Merge Cond: (vz.id = a56.id)
19. 2.869 307.889 ↑ 1.0 21,768 1

Merge Left Join (cost=120.58..67,566.81 rows=22,614 width=47) (actual time=278.914..307.889 rows=21,768 loops=1)

  • Merge Cond: (vz.id = a20.id)
20. 8.641 276.688 ↑ 1.0 21,768 1

Merge Left Join (cost=60.50..67,444.82 rows=22,614 width=39) (actual time=250.652..276.688 rows=21,768 loops=1)

  • Merge Cond: (vz.id = a55.id)
21. 13.295 13.295 ↑ 1.0 21,768 1

Index Scan using tbl_visual_zone_layerid_id_index on tbl_visual_zone vz (cost=0.42..67,322.84 rows=22,614 width=31) (actual time=0.013..13.295 rows=21,768 loops=1)

  • Index Cond: (layerid = 107)
22. 7.754 254.752 ↓ 21.8 21,768 1

Sort (cost=60.08..62.58 rows=1,000 width=12) (actual time=250.636..254.752 rows=21,768 loops=1)

  • Sort Key: a55.id
  • Sort Method: quicksort Memory: 1789kB
23. 246.998 246.998 ↓ 21.8 21,768 1

Function Scan on rf_layer_sepezo_sum a55 (cost=0.25..10.25 rows=1,000 width=12) (actual time=245.575..246.998 rows=21,768 loops=1)

24. 0.117 28.332 ↑ 2.2 459 1

Sort (cost=60.08..62.58 rows=1,000 width=12) (actual time=28.260..28.332 rows=459 loops=1)

  • Sort Key: a20.id
  • Sort Method: quicksort Memory: 46kB
25. 28.215 28.215 ↑ 2.2 459 1

Function Scan on rf_layer_sepezoco_sum a20 (cost=0.25..10.25 rows=1,000 width=12) (actual time=28.189..28.215 rows=459 loops=1)

26. 7.763 277.515 ↓ 21.8 21,768 1

Sort (cost=60.08..62.58 rows=1,000 width=12) (actual time=273.471..277.515 rows=21,768 loops=1)

  • Sort Key: a56.id
  • Sort Method: quicksort Memory: 1789kB
27. 269.752 269.752 ↓ 21.8 21,768 1

Function Scan on rf_layer_sepezo_sum a56 (cost=0.25..10.25 rows=1,000 width=12) (actual time=268.333..269.752 rows=21,768 loops=1)

28. 2.633 233.257 ↓ 7.4 7,400 1

Sort (cost=60.08..62.58 rows=1,000 width=12) (actual time=231.798..233.257 rows=7,400 loops=1)

  • Sort Key: a60.id
  • Sort Method: quicksort Memory: 539kB
29. 230.624 230.624 ↓ 7.4 7,400 1

Function Scan on rf_layer_sepezo_sum a60 (cost=0.25..10.25 rows=1,000 width=12) (actual time=230.160..230.624 rows=7,400 loops=1)

30. 0.106 29.013 ↑ 2.2 459 1

Sort (cost=60.08..62.58 rows=1,000 width=12) (actual time=28.950..29.013 rows=459 loops=1)

  • Sort Key: a53.id
  • Sort Method: quicksort Memory: 46kB
31. 28.907 28.907 ↑ 2.2 459 1

Function Scan on rf_layer_sepezoco_sum a53 (cost=0.25..10.25 rows=1,000 width=12) (actual time=28.877..28.907 rows=459 loops=1)

32. 0.786 217.488 ↓ 2.1 2,135 1

Sort (cost=60.08..62.58 rows=1,000 width=12) (actual time=217.024..217.488 rows=2,135 loops=1)

  • Sort Key: a61.id
  • Sort Method: quicksort Memory: 197kB
33. 216.702 216.702 ↓ 2.1 2,135 1

Function Scan on rf_layer_sepezo_sum a61 (cost=0.25..10.25 rows=1,000 width=12) (actual time=216.561..216.702 rows=2,135 loops=1)

34. 8.275 639.532 ↓ 21.8 21,768 1

Sort (cost=60.08..62.58 rows=1,000 width=36) (actual time=635.401..639.532 rows=21,768 loops=1)

  • Sort Key: a64.id
  • Sort Method: quicksort Memory: 2183kB
35. 631.257 631.257 ↓ 21.8 21,768 1

Function Scan on cf_layer_sepezo_sum_mp a64 (cost=0.25..10.25 rows=1,000 width=36) (actual time=626.073..631.257 rows=21,768 loops=1)

36. 0.763 214.429 ↓ 2.1 2,141 1

Sort (cost=60.08..62.58 rows=1,000 width=12) (actual time=214.007..214.429 rows=2,141 loops=1)

  • Sort Key: a92.id
  • Sort Method: quicksort Memory: 197kB
37. 213.666 213.666 ↓ 2.1 2,141 1

Function Scan on rf_layer_sepezo_sum a92 (cost=0.25..10.25 rows=1,000 width=12) (actual time=213.519..213.666 rows=2,141 loops=1)

38. 0.141 215.980 ↑ 3.3 301 1

Sort (cost=60.08..62.58 rows=1,000 width=12) (actual time=215.890..215.980 rows=301 loops=1)

  • Sort Key: a62.id
  • Sort Method: quicksort Memory: 39kB
39. 215.839 215.839 ↑ 3.3 301 1

Function Scan on rf_layer_sepezo_sum a62 (cost=0.25..10.25 rows=1,000 width=12) (actual time=215.816..215.839 rows=301 loops=1)

40. 298.332 4,207.855 ↓ 1,327.8 1,327,848 1

Sort (cost=60.08..62.58 rows=1,000 width=12) (actual time=4,105.582..4,207.855 rows=1,327,848 loops=1)

  • Sort Key: a67.id
  • Sort Method: quicksort Memory: 111395kB
41. 3,909.523 3,909.523 ↓ 1,327.8 1,327,848 1

Function Scan on cf_layer_acq_mp a67 (cost=0.25..10.25 rows=1,000 width=12) (actual time=3,206.404..3,909.523 rows=1,327,848 loops=1)

42. 1.203 215.790 ↓ 18.4 18,423 1

Sort (cost=60.08..62.58 rows=1,000 width=12) (actual time=214.637..215.790 rows=18,423 loops=1)

  • Sort Key: a93.id
  • Sort Method: quicksort Memory: 39kB
43. 214.587 214.587 ↑ 3.3 303 1

Function Scan on rf_layer_sepezo_sum a93 (cost=0.25..10.25 rows=1,000 width=12) (actual time=214.567..214.587 rows=303 loops=1)

44. 61.330 305.506 ↓ 1,030.7 1,030,657 1

Sort (cost=60.08..62.58 rows=1,000 width=12) (actual time=247.045..305.506 rows=1,030,657 loops=1)

  • Sort Key: a70.id
  • Sort Method: quicksort Memory: 1561kB
45. 244.176 244.176 ↓ 16.9 16,897 1

Function Scan on rf_layer_sepezo_sum a70 (cost=0.25..10.25 rows=1,000 width=12) (actual time=243.070..244.176 rows=16,897 loops=1)

46. 39.235 261.811 ↓ 602.3 602,254 1

Sort (cost=60.08..62.58 rows=1,000 width=12) (actual time=224.290..261.811 rows=602,254 loops=1)

  • Sort Key: a58.id
  • Sort Method: quicksort Memory: 847kB
47. 222.576 222.576 ↓ 9.9 9,874 1

Function Scan on rf_layer_sepezo_sum a58 (cost=0.25..10.25 rows=1,000 width=12) (actual time=221.910..222.576 rows=9,874 loops=1)

48. 38.144 260.251 ↓ 602.3 602,254 1

Sort (cost=60.08..62.58 rows=1,000 width=12) (actual time=223.750..260.251 rows=602,254 loops=1)

  • Sort Key: a96.id
  • Sort Method: quicksort Memory: 847kB
49. 222.107 222.107 ↓ 9.9 9,874 1

Function Scan on rf_layer_sepezo_sum a96 (cost=0.25..10.25 rows=1,000 width=12) (actual time=221.490..222.107 rows=9,874 loops=1)

50. 11.973 223.330 ↓ 187.3 187,271 1

Sort (cost=60.08..62.58 rows=1,000 width=12) (actual time=211.856..223.330 rows=187,271 loops=1)

  • Sort Key: a59.id
  • Sort Method: quicksort Memory: 240kB
51. 211.357 211.357 ↓ 3.1 3,071 1

Function Scan on rf_layer_sepezo_sum a59 (cost=0.25..10.25 rows=1,000 width=12) (actual time=211.155..211.357 rows=3,071 loops=1)

52. 11.820 227.231 ↓ 187.3 187,271 1

Sort (cost=60.08..62.58 rows=1,000 width=12) (actual time=215.886..227.231 rows=187,271 loops=1)

  • Sort Key: a97.id
  • Sort Method: quicksort Memory: 240kB
53. 215.411 215.411 ↓ 3.1 3,071 1

Function Scan on rf_layer_sepezo_sum a97 (cost=0.25..10.25 rows=1,000 width=12) (actual time=215.221..215.411 rows=3,071 loops=1)

54. 23.329 244.017 ↓ 379.5 379,543 1

Sort (cost=60.08..62.58 rows=1,000 width=12) (actual time=221.654..244.017 rows=379,543 loops=1)

  • Sort Key: a69.id
  • Sort Method: quicksort Memory: 484kB
55. 220.688 220.688 ↓ 6.2 6,223 1

Function Scan on rf_layer_sepezo_sum a69 (cost=0.25..10.25 rows=1,000 width=12) (actual time=220.285..220.688 rows=6,223 loops=1)

56. 8.732 220.546 ↓ 145.2 145,242 1

Sort (cost=60.08..62.58 rows=1,000 width=12) (actual time=212.172..220.546 rows=145,242 loops=1)

  • Sort Key: a94.id
  • Sort Method: quicksort Memory: 208kB
57. 211.814 211.814 ↓ 2.4 2,382 1

Function Scan on rf_layer_sepezo_sum a94 (cost=0.25..10.25 rows=1,000 width=12) (actual time=211.657..211.814 rows=2,382 loops=1)

58. 1.129 208.026 ↓ 18.5 18,545 1

Sort (cost=60.08..62.58 rows=1,000 width=12) (actual time=206.944..208.026 rows=18,545 loops=1)

  • Sort Key: a95.id
  • Sort Method: quicksort Memory: 39kB
59. 206.897 206.897 ↑ 3.3 305 1

Function Scan on rf_layer_sepezo_sum a95 (cost=0.25..10.25 rows=1,000 width=12) (actual time=206.875..206.897 rows=305 loops=1)

Planning time : 2.559 ms
Execution time : 12,775.915 ms