explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S7CE

Settings
# exclusive inclusive rows x rows loops node
1. 10,357.173 115,103.214 ↑ 3.0 3 1

Append (cost=5,347,757.51..18,156,599.64 rows=9 width=3,112) (actual time=40,458.552..115,103.214 rows=3 loops=1)

2. 0.009 104,746.041 ↑ 4.0 2 1

Result (cost=5,347,757.51..15,909,821.16 rows=8 width=3,112) (actual time=40,458.551..104,746.041 rows=2 loops=1)

3. 0.003 104,746.032 ↑ 4.0 2 1

Append (cost=5,347,757.51..15,909,820.92 rows=8 width=2,888) (actual time=40,458.545..104,746.032 rows=2 loops=1)

4. 0.011 40,458.558 ↑ 1.0 1 1

Subquery Scan on *SELECT* 1 (cost=5,347,757.51..5,347,757.72 rows=1 width=845) (actual time=40,458.545..40,458.558 rows=1 loops=1)

5. 0.017 40,458.547 ↑ 1.0 1 1

Group (cost=5,347,757.51..5,347,757.69 rows=1 width=621) (actual time=40,458.535..40,458.547 rows=1 loops=1)

  • Group Key: f_opendata_fnsrf.nalogyear, d_egr_fnsrf_region.no_code, sumworker_r.sumworker_value, sumout_r.sumout_value, sumin_r.sumin_value, d_egr_fnsrf_region.citycode, d_egr_fnsrf_region.regioncode, d_egr_fnsrf_region.ogrn, d_egr_fnsrf_region.cityname, d_egr_fnsrf_region.regionname, d_egr_fnsrf_region.namefull, d_egr_fnsrf_region.no_name, d_org_fnsrf.inn
6. 0.114 40,458.530 ↓ 1.6 8 1

Sort (cost=5,347,757.51..5,347,757.53 rows=5 width=429) (actual time=40,458.529..40,458.530 rows=8 loops=1)

  • Sort Key: f_opendata_fnsrf.nalogyear, d_egr_fnsrf_region.no_code, sumworker_r.sumworker_value, sumout_r.sumout_value, sumin_r.sumin_value, d_egr_fnsrf_region.citycode, d_egr_fnsrf_region.regioncode, d_egr_fnsrf_region.ogrn, d_egr_fnsrf_region.cityname, d_egr_fnsrf_region.regionname, d_egr_fnsrf_region.namefull, d_egr_fnsrf_region.no_name
  • Sort Method: quicksort Memory: 29kB
7. 0.008 40,458.416 ↓ 1.6 8 1

Nested Loop Left Join (cost=4,316,475.49..5,347,756.10 rows=5 width=429) (actual time=40,458.357..40,458.416 rows=8 loops=1)

  • Join Filter: ((d_org_fnsrf.inn)::text = (d_egr_fnsrf_region.inn)::text)
8. 0.040 38,473.048 ↓ 1.6 8 1

Hash Left Join (cost=3,124,293.04..4,155,573.55 rows=5 width=31) (actual time=38,472.998..38,473.048 rows=8 loops=1)

  • Hash Cond: (((d_org_fnsrf.inn)::text = (sumin_r.sumin_inn)::text) AND (f_opendata_fnsrf.nalogyear = sumin_r.sumin_nalogyear))
9. 0.046 22,776.319 ↓ 1.6 8 1

Hash Left Join (cost=2,083,196.18..3,114,476.63 rows=5 width=27) (actual time=22,776.274..22,776.319 rows=8 loops=1)

  • Hash Cond: (((d_org_fnsrf.inn)::text = (sumout_r.sumout_inn)::text) AND (f_opendata_fnsrf.nalogyear = sumout_r.sumout_nalogyear))
10. 0.000 18,830.962 ↓ 1.6 8 1

Hash Left Join (cost=1,042,099.32..2,073,379.70 rows=5 width=23) (actual time=18,830.922..18,830.962 rows=8 loops=1)

  • Hash Cond: (((d_org_fnsrf.inn)::text = (sumworker_r.sumworker_inn)::text) AND (f_opendata_fnsrf.nalogyear = sumworker_r.sumworker_nalogyear))
11. 0.000 3,352.962 ↓ 1.6 8 1

Gather (cost=1,002.46..1,032,282.77 rows=5 width=19) (actual time=3,352.700..3,352.962 rows=8 loops=1)

  • Workers Planned: 6
  • Workers Launched: 5
12. 679.427 3,974.480 ↑ 1.0 1 6

Hash Join (cost=2.46..1,031,282.27 rows=1 width=19) (actual time=3,560.145..3,974.480 rows=1 loops=6)

  • Hash Cond: (f_opendata_fnsrf.reforg = d_org_fnsrf.id)
13. 3,294.603 3,294.603 ↓ 1.0 6,259,740 6

Parallel Seq Scan on f_opendata_fnsrf (cost=0.00..1,014,861.56 rows=6,254,568 width=16) (actual time=0.060..3,294.603 rows=6,259,740 loops=6)

  • Filter: (nalogyear IS NOT NULL)
  • Rows Removed by Filter: 3352616
14. 0.012 0.450 ↑ 1.0 1 6

Hash (cost=2.45..2.45 rows=1 width=19) (actual time=0.449..0.450 rows=1 loops=6)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
15. 0.438 0.438 ↑ 1.0 1 6

Index Scan using uk_d_org_fnsrfinn on d_org_fnsrf (cost=0.43..2.45 rows=1 width=19) (actual time=0.436..0.438 rows=1 loops=6)

  • Index Cond: ((inn)::text = '5919023740'::text)
16. 0.010 15,478.176 ↑ 1.0 1 1

Hash (cost=1,041,096.84..1,041,096.84 rows=1 width=23) (actual time=15,478.176..15,478.176 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
17. 0.002 15,478.166 ↑ 1.0 1 1

Subquery Scan on sumworker_r (cost=1,041,096.82..1,041,096.84 rows=1 width=23) (actual time=15,478.165..15,478.166 rows=1 loops=1)

18. 0.004 15,478.164 ↑ 1.0 1 1

Group (cost=1,041,096.82..1,041,096.83 rows=1 width=23) (actual time=15,478.163..15,478.164 rows=1 loops=1)

  • Group Key: f_opendata_fnsrf_1.value, f_opendata_fnsrf_1.nalogyear, d_org_fnsrf_1.inn
19. 0.000 15,478.160 ↑ 1.0 1 1

Sort (cost=1,041,096.82..1,041,096.83 rows=1 width=23) (actual time=15,478.159..15,478.160 rows=1 loops=1)

  • Sort Key: f_opendata_fnsrf_1.value, f_opendata_fnsrf_1.nalogyear
  • Sort Method: quicksort Memory: 25kB
20. 1.390 15,478.271 ↑ 1.0 1 1

Gather (cost=1,002.60..1,041,096.75 rows=1 width=23) (actual time=1,178.332..15,478.271 rows=1 loops=1)

  • Workers Planned: 6
  • Workers Launched: 0
21. 0.164 15,476.881 ↑ 1.0 1 1

Nested Loop (cost=2.60..1,040,096.65 rows=1 width=23) (actual time=1,177.092..15,476.881 rows=1 loops=1)

22. 8,235.622 15,476.709 ↓ 15.0 15 1

Hash Join (cost=2.46..1,040,096.47 rows=1 width=31) (actual time=1.381..15,476.709 rows=15 loops=1)

  • Hash Cond: (f_opendata_fnsrf_1.reforg = d_org_fnsrf_1.id)
23. 7,241.026 7,241.026 ↓ 6.0 57,674,135 1

Parallel Seq Scan on f_opendata_fnsrf f_opendata_fnsrf_1 (cost=0.00..1,014,861.56 rows=9,612,356 width=28) (actual time=0.011..7,241.026 rows=57,674,135 loops=1)

24. 0.006 0.061 ↑ 1.0 1 1

Hash (cost=2.45..2.45 rows=1 width=19) (actual time=0.061..0.061 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
25. 0.055 0.055 ↑ 1.0 1 1

Index Scan using uk_d_org_fnsrfinn on d_org_fnsrf d_org_fnsrf_1 (cost=0.43..2.45 rows=1 width=19) (actual time=0.053..0.055 rows=1 loops=1)

  • Index Cond: ((inn)::text = '5919023740'::text)
26. 0.008 0.008 ↓ 0.0 0 15

Index Scan using pk_d_marks_fnsrf on d_marks_fnsrf (cost=0.14..0.16 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=15)

  • Index Cond: (id = f_opendata_fnsrf_1.refmarks)
  • Filter: ((code)::text = 'SumWorker'::text)
  • Rows Removed by Filter: 1
27. 0.011 3,945.311 ↑ 1.0 1 1

Hash (cost=1,041,096.84..1,041,096.84 rows=1 width=23) (actual time=3,945.311..3,945.311 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
28. 0.002 3,945.300 ↑ 1.0 1 1

Subquery Scan on sumout_r (cost=1,041,096.82..1,041,096.84 rows=1 width=23) (actual time=3,945.299..3,945.300 rows=1 loops=1)

29. 0.005 3,945.298 ↑ 1.0 1 1

Group (cost=1,041,096.82..1,041,096.83 rows=1 width=23) (actual time=3,945.297..3,945.298 rows=1 loops=1)

  • Group Key: f_opendata_fnsrf_2.value, f_opendata_fnsrf_2.nalogyear, d_org_fnsrf_2.inn
30. 0.000 3,945.293 ↑ 1.0 1 1

Sort (cost=1,041,096.82..1,041,096.83 rows=1 width=23) (actual time=3,945.293..3,945.293 rows=1 loops=1)

  • Sort Key: f_opendata_fnsrf_2.value, f_opendata_fnsrf_2.nalogyear
  • Sort Method: quicksort Memory: 25kB
31. 8.040 3,945.419 ↑ 1.0 1 1

Gather (cost=1,002.60..1,041,096.75 rows=1 width=23) (actual time=2.322..3,945.419 rows=1 loops=1)

  • Workers Planned: 6
  • Workers Launched: 5
32. 0.044 3,937.379 ↓ 0.0 0 6

Nested Loop (cost=2.60..1,040,096.65 rows=1 width=23) (actual time=3,280.308..3,937.379 rows=0 loops=6)

33. 1,941.363 3,937.314 ↓ 2.0 2 6

Hash Join (cost=2.46..1,040,096.47 rows=1 width=31) (actual time=616.507..3,937.314 rows=2 loops=6)

  • Hash Cond: (f_opendata_fnsrf_2.reforg = d_org_fnsrf_2.id)
34. 1,994.919 1,994.919 ↑ 1.0 9,612,356 6

Parallel Seq Scan on f_opendata_fnsrf f_opendata_fnsrf_2 (cost=0.00..1,014,861.56 rows=9,612,356 width=28) (actual time=0.053..1,994.919 rows=9,612,356 loops=6)

35. 0.009 1.032 ↑ 1.0 1 6

Hash (cost=2.45..2.45 rows=1 width=19) (actual time=1.032..1.032 rows=1 loops=6)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
36. 1.023 1.023 ↑ 1.0 1 6

Index Scan using uk_d_org_fnsrfinn on d_org_fnsrf d_org_fnsrf_2 (cost=0.43..2.45 rows=1 width=19) (actual time=1.022..1.023 rows=1 loops=6)

  • Index Cond: ((inn)::text = '5919023740'::text)
37. 0.021 0.021 ↓ 0.0 0 15

Index Scan using pk_d_marks_fnsrf on d_marks_fnsrf d_marks_fnsrf_1 (cost=0.14..0.16 rows=1 width=8) (actual time=0.021..0.021 rows=0 loops=15)

  • Index Cond: (id = f_opendata_fnsrf_2.refmarks)
  • Filter: ((code)::text = 'SumOut'::text)
  • Rows Removed by Filter: 1
38. 0.011 15,696.689 ↑ 1.0 1 1

Hash (cost=1,041,096.84..1,041,096.84 rows=1 width=23) (actual time=15,696.689..15,696.689 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
39. 0.002 15,696.678 ↑ 1.0 1 1

Subquery Scan on sumin_r (cost=1,041,096.82..1,041,096.84 rows=1 width=23) (actual time=15,696.677..15,696.678 rows=1 loops=1)

40. 0.002 15,696.676 ↑ 1.0 1 1

Group (cost=1,041,096.82..1,041,096.83 rows=1 width=23) (actual time=15,696.676..15,696.676 rows=1 loops=1)

  • Group Key: f_opendata_fnsrf_3.value, f_opendata_fnsrf_3.nalogyear, d_org_fnsrf_3.inn
41. 0.000 15,696.674 ↑ 1.0 1 1

Sort (cost=1,041,096.82..1,041,096.83 rows=1 width=23) (actual time=15,696.674..15,696.674 rows=1 loops=1)

  • Sort Key: f_opendata_fnsrf_3.value, f_opendata_fnsrf_3.nalogyear
  • Sort Method: quicksort Memory: 25kB
42. 1.341 15,696.782 ↑ 1.0 1 1

Gather (cost=1,002.60..1,041,096.75 rows=1 width=23) (actual time=15,693.499..15,696.782 rows=1 loops=1)

  • Workers Planned: 6
  • Workers Launched: 0
43. 0.147 15,695.441 ↑ 1.0 1 1

Nested Loop (cost=2.60..1,040,096.65 rows=1 width=23) (actual time=15,692.295..15,695.441 rows=1 loops=1)

44. 8,311.270 15,695.287 ↓ 15.0 15 1

Hash Join (cost=2.46..1,040,096.47 rows=1 width=31) (actual time=1.445..15,695.287 rows=15 loops=1)

  • Hash Cond: (f_opendata_fnsrf_3.reforg = d_org_fnsrf_3.id)
45. 7,383.942 7,383.942 ↓ 6.0 57,674,135 1

Parallel Seq Scan on f_opendata_fnsrf f_opendata_fnsrf_3 (cost=0.00..1,014,861.56 rows=9,612,356 width=28) (actual time=0.005..7,383.942 rows=57,674,135 loops=1)

46. 0.006 0.075 ↑ 1.0 1 1

Hash (cost=2.45..2.45 rows=1 width=19) (actual time=0.075..0.075 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
47. 0.069 0.069 ↑ 1.0 1 1

Index Scan using uk_d_org_fnsrfinn on d_org_fnsrf d_org_fnsrf_3 (cost=0.43..2.45 rows=1 width=19) (actual time=0.068..0.069 rows=1 loops=1)

  • Index Cond: ((inn)::text = '5919023740'::text)
48. 0.007 0.007 ↓ 0.0 0 15

Index Scan using pk_d_marks_fnsrf on d_marks_fnsrf d_marks_fnsrf_2 (cost=0.14..0.16 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=15)

  • Index Cond: (id = f_opendata_fnsrf_3.refmarks)
  • Filter: ((code)::text = 'SumIn'::text)
  • Rows Removed by Filter: 1
49. 0.012 1,985.360 ↑ 1.0 1 8

Materialize (cost=1,192,182.46..1,192,182.48 rows=1 width=410) (actual time=248.169..248.170 rows=1 loops=8)

50. 0.004 1,985.348 ↑ 1.0 1 1

Subquery Scan on d_egr_fnsrf_region (cost=1,192,182.46..1,192,182.47 rows=1 width=410) (actual time=1,985.347..1,985.348 rows=1 loops=1)

51. 0.062 1,985.344 ↑ 1.0 1 1

Sort (cost=1,192,182.46..1,192,182.46 rows=1 width=415) (actual time=1,985.344..1,985.344 rows=1 loops=1)

  • Sort Key: d_egr_fnsrf.kpp
  • Sort Method: quicksort Memory: 25kB
52. 0.006 1,985.282 ↑ 1.0 1 1

Nested Loop Left Join (cost=1,000.85..1,192,182.40 rows=1 width=415) (actual time=1,984.463..1,985.282 rows=1 loops=1)

  • Join Filter: (((d_egr_fnsrf.inn)::text = (d_address_fnsrf.inn)::text) AND ((d_egr_fnsrf.kpp)::text = (d_address_fnsrf.kpp)::text) AND ((d_egr_fnsrf.ogrn)::text = (d_address_fnsrf.ogrn)::text))
53. 0.000 1,985.210 ↑ 1.0 1 1

Nested Loop Left Join (cost=1,000.28..1,192,178.77 rows=1 width=351) (actual time=1,984.391..1,985.210 rows=1 loops=1)

54. 7.785 1,985.247 ↑ 1.0 1 1

Gather (cost=1,000.00..1,192,176.46 rows=1 width=148) (actual time=1,984.314..1,985.247 rows=1 loops=1)

  • Workers Planned: 6
  • Workers Launched: 5
55. 1,977.462 1,977.462 ↓ 0.0 0 6

Parallel Seq Scan on d_egr_fnsrf (cost=0.00..1,191,176.36 rows=1 width=148) (actual time=1,927.712..1,977.462 rows=0 loops=6)

  • Filter: ((inn)::text = '5919023740'::text)
  • Rows Removed by Filter: 4290269
56. 0.067 0.067 ↑ 1.0 1 1

Index Scan using uk_d_registrars_fnsrfcoderegty on d_registrars_fnsrf (cost=0.28..2.30 rows=1 width=208) (actual time=0.067..0.067 rows=1 loops=1)

  • Index Cond: (((d_egr_fnsrf.noregcode)::text = (code)::text) AND ((regtype)::text = 'NORegCode'::text))
57. 0.066 0.066 ↑ 2.0 1 1

Index Scan using uk_d_address_fnsrfinnkppogrn on d_address_fnsrf (cost=0.56..3.59 rows=2 width=96) (actual time=0.066..0.066 rows=1 loops=1)

  • Index Cond: ((inn)::text = '5919023740'::text)
58. 0.013 64,287.471 ↑ 7.0 1 1

Subquery Scan on *SELECT* 2 (cost=10,562,062.70..10,562,063.16 rows=7 width=705) (actual time=64,287.450..64,287.471 rows=1 loops=1)

59. 0.026 64,287.458 ↑ 7.0 1 1

Group (cost=10,562,062.70..10,562,063.02 rows=7 width=617) (actual time=64,287.438..64,287.458 rows=1 loops=1)

  • Group Key: eshn_r.eshn_value, smp_r.smp_value, envd_r.envd_value, spr_r.spr_value, kgnotv_r.kgnotv_value, kgnob_r.kgnob_value, d_egr_fnsrf_region_1.no_code, usn_r.usn_value, d_egr_fnsrf_region_1.citycode, d_egr_fnsrf_region_1.regioncode, d_egr_fnsrf_region_1.ogrn, d_egr_fnsrf_region_1.cityname, d_egr_fnsrf_region_1.regionname, d_egr_fnsrf_region_1.namefull, d_egr_fnsrf_region_1.no_name, f_opendata_fnsrf_5.value, d_org_fnsrf_4.inn
60. 0.147 64,287.432 ↓ 2.1 15 1

Sort (cost=10,562,062.70..10,562,062.72 rows=7 width=441) (actual time=64,287.431..64,287.432 rows=15 loops=1)

  • Sort Key: eshn_r.eshn_value, smp_r.smp_value, envd_r.envd_value, spr_r.spr_value, kgnotv_r.kgnotv_value, kgnob_r.kgnob_value, d_egr_fnsrf_region_1.no_code, usn_r.usn_value, d_egr_fnsrf_region_1.citycode, d_egr_fnsrf_region_1.regioncode, d_egr_fnsrf_region_1.ogrn, d_egr_fnsrf_region_1.cityname, d_egr_fnsrf_region_1.regionname, d_egr_fnsrf_region_1.namefull, d_egr_fnsrf_region_1.no_name, f_opendata_fnsrf_5.value
  • Sort Method: quicksort Memory: 32kB
61. 3,499.882 64,287.285 ↓ 2.1 15 1

Nested Loop Left Join (cost=8,481,865.16..10,562,055.13 rows=7 width=441) (actual time=49,157.977..64,287.285 rows=15 loops=1)

  • Join Filter: ((d_org_fnsrf_4.inn)::text = (smp_r.smp_inn)::text)
62. 8,240.019 60,787.403 ↓ 2.1 15 1

Nested Loop Left Join (cost=7,440,768.35..9,520,958.20 rows=7 width=437) (actual time=45,658.117..60,787.403 rows=15 loops=1)

  • Join Filter: ((d_org_fnsrf_4.inn)::text = (kgnotv_r.kgnotv_inn)::text)
63. 3,516.068 52,547.384 ↓ 2.1 15 1

Nested Loop Left Join (cost=6,399,671.55..8,479,861.27 rows=7 width=433) (actual time=37,418.112..52,547.384 rows=15 loops=1)

  • Join Filter: ((d_org_fnsrf_4.inn)::text = (d_org_fnsrf_5.inn)::text)
64. 8,254.396 49,031.316 ↓ 2.1 15 1

Nested Loop Left Join (cost=6,398,668.95..7,438,764.41 rows=7 width=429) (actual time=33,902.058..49,031.316 rows=15 loops=1)

  • Join Filter: ((d_org_fnsrf_4.inn)::text = (kgnob_r.kgnob_inn)::text)
65. 3,510.707 40,776.920 ↓ 2.1 15 1

Nested Loop Left Join (cost=5,357,572.14..6,397,667.48 rows=7 width=425) (actual time=25,647.675..40,776.920 rows=15 loops=1)

  • Join Filter: ((d_org_fnsrf_4.inn)::text = (usn_r.usn_inn)::text)
66. 8,252.079 37,266.213 ↓ 2.1 15 1

Nested Loop Left Join (cost=4,316,475.34..5,356,570.55 rows=7 width=421) (actual time=22,136.985..37,266.213 rows=15 loops=1)

  • Join Filter: ((d_org_fnsrf_4.inn)::text = (spr_r.spr_inn)::text)
67. 0.017 29,014.134 ↓ 2.1 15 1

Nested Loop Left Join (cost=3,275,378.53..4,315,473.61 rows=7 width=417) (actual time=13,884.926..29,014.134 rows=15 loops=1)

  • Join Filter: ((d_org_fnsrf_4.inn)::text = (eshn_r.eshn_inn)::text)
68. 0.028 25,510.822 ↓ 2.1 15 1

Nested Loop Left Join (cost=2,234,281.72..3,274,376.68 rows=7 width=413) (actual time=10,381.632..25,510.822 rows=15 loops=1)

  • Join Filter: ((d_org_fnsrf_4.inn)::text = (envd_r.envd_inn)::text)
69. 0.000 17,227.749 ↓ 2.1 15 1

Nested Loop Left Join (cost=1,193,184.92..2,233,279.75 rows=7 width=409) (actual time=2,098.581..17,227.749 rows=15 loops=1)

  • Join Filter: ((d_org_fnsrf_4.inn)::text = (d_egr_fnsrf_region_1.inn)::text)
70. 1.233 15,131.747 ↓ 2.1 15 1

Gather (cost=1,002.46..1,041,097.17 rows=7 width=11) (actual time=2.496..15,131.747 rows=15 loops=1)

  • Workers Planned: 6
  • Workers Launched: 0
71. 8,053.759 15,130.514 ↓ 15.0 15 1

Hash Join (cost=2.46..1,040,096.47 rows=1 width=11) (actual time=1.394..15,130.514 rows=15 loops=1)

  • Hash Cond: (f_opendata_fnsrf_4.reforg = d_org_fnsrf_4.id)
72. 7,076.698 7,076.698 ↓ 6.0 57,674,135 1

Parallel Seq Scan on f_opendata_fnsrf f_opendata_fnsrf_4 (cost=0.00..1,014,861.56 rows=9,612,356 width=8) (actual time=0.005..7,076.698 rows=57,674,135 loops=1)

73. 0.013 0.057 ↑ 1.0 1 1

Hash (cost=2.45..2.45 rows=1 width=19) (actual time=0.057..0.057 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
74. 0.044 0.044 ↑ 1.0 1 1

Index Scan using uk_d_org_fnsrfinn on d_org_fnsrf d_org_fnsrf_4 (cost=0.43..2.45 rows=1 width=19) (actual time=0.043..0.044 rows=1 loops=1)

  • Index Cond: ((inn)::text = '5919023740'::text)
75. 0.010 2,096.085 ↑ 1.0 1 15

Materialize (cost=1,192,182.46..1,192,182.48 rows=1 width=410) (actual time=139.739..139.739 rows=1 loops=15)

76. 0.003 2,096.075 ↑ 1.0 1 1

Subquery Scan on d_egr_fnsrf_region_1 (cost=1,192,182.46..1,192,182.47 rows=1 width=410) (actual time=2,096.073..2,096.075 rows=1 loops=1)

77. 0.032 2,096.072 ↑ 1.0 1 1

Sort (cost=1,192,182.46..1,192,182.46 rows=1 width=415) (actual time=2,096.071..2,096.072 rows=1 loops=1)

  • Sort Key: d_egr_fnsrf_1.kpp
  • Sort Method: quicksort Memory: 25kB
78. 0.006 2,096.040 ↑ 1.0 1 1

Nested Loop Left Join (cost=1,000.85..1,192,182.40 rows=1 width=415) (actual time=2,096.036..2,096.040 rows=1 loops=1)

  • Join Filter: (((d_egr_fnsrf_1.inn)::text = (d_address_fnsrf_1.inn)::text) AND ((d_egr_fnsrf_1.kpp)::text = (d_address_fnsrf_1.kpp)::text) AND ((d_egr_fnsrf_1.ogrn)::text = (d_address_fnsrf_1.ogrn)::text))
79. 0.000 2,095.972 ↑ 1.0 1 1

Nested Loop Left Join (cost=1,000.28..1,192,178.77 rows=1 width=351) (actual time=2,095.968..2,095.972 rows=1 loops=1)

80. 5.871 2,096.030 ↑ 1.0 1 1

Gather (cost=1,000.00..1,192,176.46 rows=1 width=148) (actual time=2,095.905..2,096.030 rows=1 loops=1)

  • Workers Planned: 6
  • Workers Launched: 4
81. 2,090.159 2,090.159 ↓ 0.0 0 5

Parallel Seq Scan on d_egr_fnsrf d_egr_fnsrf_1 (cost=0.00..1,191,176.36 rows=1 width=148) (actual time=2,021.071..2,090.159 rows=0 loops=5)

  • Filter: ((inn)::text = '5919023740'::text)
  • Rows Removed by Filter: 5148323
82. 0.053 0.053 ↑ 1.0 1 1

Index Scan using uk_d_registrars_fnsrfcoderegty on d_registrars_fnsrf d_registrars_fnsrf_1 (cost=0.28..2.30 rows=1 width=208) (actual time=0.053..0.053 rows=1 loops=1)

  • Index Cond: (((d_egr_fnsrf_1.noregcode)::text = (code)::text) AND ((regtype)::text = 'NORegCode'::text))
83. 0.062 0.062 ↑ 2.0 1 1

Index Scan using uk_d_address_fnsrfinnkppogrn on d_address_fnsrf d_address_fnsrf_1 (cost=0.56..3.59 rows=2 width=96) (actual time=0.062..0.062 rows=1 loops=1)

  • Index Cond: ((inn)::text = '5919023740'::text)
84. 0.015 8,283.045 ↑ 1.0 1 15

Materialize (cost=1,041,096.81..1,041,096.83 rows=1 width=15) (actual time=552.203..552.203 rows=1 loops=15)

85. 0.002 8,283.030 ↑ 1.0 1 1

Subquery Scan on envd_r (cost=1,041,096.81..1,041,096.83 rows=1 width=15) (actual time=8,283.029..8,283.030 rows=1 loops=1)

86. 0.004 8,283.028 ↑ 1.0 1 1

Group (cost=1,041,096.81..1,041,096.82 rows=1 width=15) (actual time=8,283.028..8,283.028 rows=1 loops=1)

  • Group Key: d_org_fnsrf_6.inn, f_opendata_fnsrf_6.value
87. 0.000 8,283.024 ↑ 1.0 1 1

Sort (cost=1,041,096.81..1,041,096.81 rows=1 width=15) (actual time=8,283.023..8,283.024 rows=1 loops=1)

  • Sort Key: f_opendata_fnsrf_6.value
  • Sort Method: quicksort Memory: 25kB
88. 5.452 8,283.138 ↑ 1.0 1 1

Gather (cost=1,002.60..1,041,096.75 rows=1 width=15) (actual time=3,933.290..8,283.138 rows=1 loops=1)

  • Workers Planned: 6
  • Workers Launched: 1
89. 0.091 8,277.686 ↓ 0.0 0 2

Nested Loop (cost=2.60..1,040,096.65 rows=1 width=15) (actual time=6,102.891..8,277.686 rows=0 loops=2)

90. 4,217.299 8,277.585 ↓ 8.0 8 2

Hash Join (cost=2.46..1,040,096.47 rows=1 width=23) (actual time=263.564..8,277.585 rows=8 loops=2)

  • Hash Cond: (f_opendata_fnsrf_6.reforg = d_org_fnsrf_6.id)
91. 4,059.947 4,059.947 ↓ 3.0 28,837,068 2

Parallel Seq Scan on f_opendata_fnsrf f_opendata_fnsrf_6 (cost=0.00..1,014,861.56 rows=9,612,356 width=20) (actual time=0.034..4,059.947 rows=28,837,068 loops=2)

92. 0.007 0.339 ↑ 1.0 1 2

Hash (cost=2.45..2.45 rows=1 width=19) (actual time=0.338..0.339 rows=1 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
93. 0.332 0.332 ↑ 1.0 1 2

Index Scan using uk_d_org_fnsrfinn on d_org_fnsrf d_org_fnsrf_6 (cost=0.43..2.45 rows=1 width=19) (actual time=0.330..0.332 rows=1 loops=2)

  • Index Cond: ((inn)::text = '5919023740'::text)
94. 0.010 0.010 ↓ 0.0 0 15

Index Scan using pk_d_marks_fnsrf on d_marks_fnsrf d_marks_fnsrf_4 (cost=0.14..0.16 rows=1 width=8) (actual time=0.010..0.010 rows=0 loops=15)

  • Index Cond: (id = f_opendata_fnsrf_6.refmarks)
  • Filter: ((code)::text = 'ENVD'::text)
  • Rows Removed by Filter: 1
95. 0.019 3,503.295 ↑ 1.0 1 15

Materialize (cost=1,041,096.81..1,041,096.83 rows=1 width=15) (actual time=233.553..233.553 rows=1 loops=15)

96. 0.002 3,503.276 ↑ 1.0 1 1

Subquery Scan on eshn_r (cost=1,041,096.81..1,041,096.83 rows=1 width=15) (actual time=3,503.275..3,503.276 rows=1 loops=1)

97. 0.003 3,503.274 ↑ 1.0 1 1

Group (cost=1,041,096.81..1,041,096.82 rows=1 width=15) (actual time=3,503.273..3,503.274 rows=1 loops=1)

  • Group Key: d_org_fnsrf_7.inn, f_opendata_fnsrf_7.value
98. 0.000 3,503.271 ↑ 1.0 1 1

Sort (cost=1,041,096.81..1,041,096.81 rows=1 width=15) (actual time=3,503.270..3,503.271 rows=1 loops=1)

  • Sort Key: f_opendata_fnsrf_7.value
  • Sort Method: quicksort Memory: 25kB
99. 3,503.379 3,503.379 ↑ 1.0 1 1

Gather (cost=1,002.60..1,041,096.75 rows=1 width=15) (actual time=3,503.143..3,503.379 rows=1 loops=1)

  • Workers Planned: 6
  • Workers Launched: 4