explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jC8o

Settings
# exclusive inclusive rows x rows loops node
1. 0.277 14,727.261 ↓ 15.0 15 1

GroupAggregate (cost=24,507.26..24,507.41 rows=1 width=475) (actual time=14,727.018..14,727.261 rows=15 loops=1)

  • Group Key: v_1.yil, v_1.hafta, wrvi.isemri_makine_plan_id, imp.entegrasyon_kodu, i.musteri_adi, i.siparis_kodu, u.urun_kodu, u.urun_adi, imp.isemri_makine_plan_durum_id, impd.isemri_makine_plan_durum_kodu, imp.makine_id, m.makine_kodu, m.makine_adi, imp.gercek_baslangic_tarihi, imp.gercek_bitis_tarihi, imp.devir, b.birim_kodu, sb.birim_kodu, p.personel_id
2. 0.235 14,726.984 ↓ 25.0 25 1

Sort (cost=24,507.26..24,507.27 rows=1 width=416) (actual time=14,726.982..14,726.984 rows=25 loops=1)

  • Sort Key: wrvi.isemri_makine_plan_id, imp.entegrasyon_kodu, i.musteri_adi, i.siparis_kodu, u.urun_kodu, u.urun_adi, imp.isemri_makine_plan_durum_id, impd.isemri_makine_plan_durum_kodu, imp.makine_id, m.makine_kodu, m.makine_adi, imp.gercek_baslangic_tarihi, imp.gercek_bitis_tarihi, imp.devir, b.birim_kodu, sb.birim_kodu
  • Sort Method: quicksort Memory: 37kB
3. 0.044 14,726.749 ↓ 25.0 25 1

Nested Loop (cost=23,131.31..24,507.25 rows=1 width=416) (actual time=14,305.359..14,726.749 rows=25 loops=1)

4. 0.072 14,726.580 ↓ 25.0 25 1

Nested Loop (cost=23,131.18..24,507.09 rows=1 width=405) (actual time=14,305.296..14,726.580 rows=25 loops=1)

5. 0.057 14,726.458 ↓ 25.0 25 1

Nested Loop (cost=23,131.04..24,506.93 rows=1 width=382) (actual time=14,305.290..14,726.458 rows=25 loops=1)

6. 0.047 14,726.201 ↓ 25.0 25 1

Nested Loop (cost=23,130.75..24,506.17 rows=1 width=345) (actual time=14,305.274..14,726.201 rows=25 loops=1)

7. 0.061 14,726.029 ↓ 25.0 25 1

Nested Loop (cost=23,130.47..24,505.80 rows=1 width=318) (actual time=14,305.263..14,726.029 rows=25 loops=1)

8. 0.079 14,725.843 ↓ 25.0 25 1

Nested Loop (cost=23,130.19..24,505.44 rows=1 width=318) (actual time=14,305.238..14,725.843 rows=25 loops=1)

9. 58.311 14,725.689 ↓ 25.0 25 1

Nested Loop (cost=23,129.91..24,504.30 rows=1 width=278) (actual time=14,305.226..14,725.689 rows=25 loops=1)

  • Join Filter: ((v.vardiya_id = v_1.vardiya_id) AND (wrvip.isemri_makine_plan_id = wrvi.isemri_makine_plan_id))
  • Rows Removed by Join Filter: 330557
10. 3.152 295.986 ↓ 714.0 714 1

Nested Loop (cost=4,550.47..4,840.61 rows=1 width=878) (actual time=187.091..295.986 rows=714 loops=1)

  • Join Filter: (p.personel_gorev_id = pg.personel_gorev_id)
11.          

CTE w_randiman_vrd_isemri_personel

12. 59.593 247.723 ↓ 1.0 12,451 1

GroupAggregate (cost=3,274.17..4,550.20 rows=12,449 width=208) (actual time=186.793..247.723 rows=12,451 loops=1)

  • Group Key: rvip.vardiya_id, vi.isemri_makine_plan_id, rvip.personel_id, rvip.personel_vardiya_grup_id, rvip.sayac_birim_id, rvip.birim_id
13. 24.483 188.130 ↓ 1.0 12,490 1

Sort (cost=3,274.17..3,305.30 rows=12,449 width=106) (actual time=186.759..188.130 rows=12,490 loops=1)

  • Sort Key: rvip.vardiya_id, vi.isemri_makine_plan_id, rvip.personel_id, rvip.personel_vardiya_grup_id, rvip.sayac_birim_id, rvip.birim_id
  • Sort Method: quicksort Memory: 2147kB
14. 10.944 163.647 ↓ 1.0 12,490 1

Hash Join (cost=1,727.53..2,427.41 rows=12,449 width=106) (actual time=117.161..163.647 rows=12,490 loops=1)

  • Hash Cond: (vvi.veri_isemri_id = vi.veri_isemri_id)
15. 12.661 120.420 ↓ 1.0 12,490 1

Hash Join (cost=1,514.28..2,181.45 rows=12,449 width=106) (actual time=84.857..120.420 rows=12,490 loops=1)

  • Hash Cond: (rvip.veri_vrd_isemri_id = vvi.veri_vrd_isemri_id)
16. 23.654 23.654 ↓ 1.0 12,490 1

Seq Scan on randiman_vrd_isemri_personel rvip (cost=0.00..634.49 rows=12,449 width=106) (actual time=0.073..23.654 rows=12,490 loops=1)

17. 13.707 84.105 ↑ 1.1 39,990 1

Hash (cost=969.68..969.68 rows=43,568 width=8) (actual time=84.105..84.105 rows=39,990 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2075kB
18. 70.398 70.398 ↑ 1.1 39,990 1

Seq Scan on veri_vrd_isemri vvi (cost=0.00..969.68 rows=43,568 width=8) (actual time=0.021..70.398 rows=39,990 loops=1)

19. 1.427 32.283 ↑ 1.1 4,119 1

Hash (cost=158.11..158.11 rows=4,411 width=8) (actual time=32.283..32.283 rows=4,119 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 225kB
20. 30.856 30.856 ↑ 1.1 4,119 1

Seq Scan on veri_isemri vi (cost=0.00..158.11 rows=4,411 width=8) (actual time=0.027..30.856 rows=4,119 loops=1)

21. 2.678 292.120 ↓ 714.0 714 1

Nested Loop (cost=0.28..289.28 rows=1 width=136) (actual time=187.078..292.120 rows=714 loops=1)

22. 5.246 280.874 ↓ 714.0 714 1

Nested Loop (cost=0.28..286.07 rows=1 width=132) (actual time=187.061..280.874 rows=714 loops=1)

  • Join Filter: (v.vardiya_zaman_id = vz.vardiya_zaman_id)
  • Rows Removed by Join Filter: 719
23. 1.582 274.200 ↓ 714.0 714 1

Nested Loop (cost=0.28..285.00 rows=1 width=136) (actual time=187.044..274.200 rows=714 loops=1)

24. 1.641 268.334 ↓ 714.0 714 1

Nested Loop (cost=0.00..283.93 rows=1 width=132) (actual time=186.998..268.334 rows=714 loops=1)

  • Join Filter: (wrvip.personel_vardiya_grup_id = pvg.personel_vardiya_grup_id)
  • Rows Removed by Join Filter: 714
25. 266.693 266.693 ↓ 11.5 714 1

CTE Scan on w_randiman_vrd_isemri_personel wrvip (cost=0.00..280.10 rows=62 width=144) (actual time=186.955..266.693 rows=714 loops=1)

  • Filter: (personel_id = 57)
  • Rows Removed by Filter: 11737
26. 0.000 0.000 ↑ 1.5 2 714

Materialize (cost=0.00..1.04 rows=3 width=4) (actual time=0.000..0.000 rows=2 loops=714)

27. 0.029 0.029 ↑ 1.5 2 1

Seq Scan on personel_vardiya_gruplari pvg (cost=0.00..1.03 rows=3 width=4) (actual time=0.028..0.029 rows=2 loops=1)

28. 4.284 4.284 ↑ 1.0 1 714

Index Scan using pk_vardiyalar on vardiyalar v (cost=0.28..1.07 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=714)

  • Index Cond: (vardiya_id = wrvip.vardiya_id)
29. 1.428 1.428 ↑ 1.5 2 714

Seq Scan on vardiya_zamanlari vz (cost=0.00..1.03 rows=3 width=4) (actual time=0.002..0.002 rows=2 loops=714)

30. 8.568 8.568 ↑ 1.0 1 714

Seq Scan on personeller p (cost=0.00..3.20 rows=1 width=8) (actual time=0.003..0.012 rows=1 loops=714)

  • Filter: (personel_id = 57)
  • Rows Removed by Filter: 47
31. 0.714 0.714 ↑ 6.0 1 714

Seq Scan on personel_gorevleri pg (cost=0.00..1.06 rows=6 width=4) (actual time=0.001..0.001 rows=1 loops=714)

32. 490.054 14,371.392 ↑ 1.1 463 714

Hash Left Join (cost=18,579.44..19,651.43 rows=490 width=882) (actual time=16.134..20.128 rows=463 loops=714)

  • Hash Cond: ((wrvi.vardiya_id = wrvip_1.vardiya_id) AND (wrvi.isemri_makine_plan_id = wrvip_1.isemri_makine_plan_id))
33.          

CTE w_randiman_vrd_isemri

34. 358.855 639.992 ↑ 1.0 39,954 1

GroupAggregate (cost=8,272.93..13,671.58 rows=39,990 width=260) (actual time=260.875..639.992 rows=39,954 loops=1)

  • Group Key: rvi.vardiya_id, vi_1.isemri_makine_plan_id, vi_1.makine_id, rvi.sayac_birim_id, rvi.birim_id
35. 136.874 281.137 ↑ 1.0 39,990 1

Sort (cost=8,272.93..8,372.90 rows=39,990 width=131) (actual time=260.840..281.137 rows=39,990 loops=1)

  • Sort Key: rvi.vardiya_id, vi_1.isemri_makine_plan_id, vi_1.makine_id, rvi.sayac_birim_id, rvi.birim_id
  • Sort Method: external merge Disk: 5624kB
36. 35.612 144.263 ↑ 1.0 39,990 1

Hash Join (cost=213.25..2,479.22 rows=39,990 width=131) (actual time=30.879..144.263 rows=39,990 loops=1)

  • Hash Cond: (rvi.veri_isemri_id = vi_1.veri_isemri_id)
37. 77.864 77.864 ↑ 1.0 39,990 1

Seq Scan on randiman_vrd_isemri rvi (cost=0.00..2,160.90 rows=39,990 width=127) (actual time=0.067..77.864 rows=39,990 loops=1)

38. 1.573 30.787 ↑ 1.1 4,119 1

Hash (cost=158.11..158.11 rows=4,411 width=12) (actual time=30.787..30.787 rows=4,119 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 241kB
39. 29.214 29.214 ↑ 1.1 4,119 1

Seq Scan on veri_isemri vi_1 (cost=0.00..158.11 rows=4,411 width=12) (actual time=0.016..29.214 rows=4,119 loops=1)

40.          

CTE w_randiman_vrd_isemri_personel

41. 36.028 254.487 ↓ 138.1 12,433 1

GroupAggregate (cost=4,869.91..4,876.43 rows=90 width=192) (actual time=215.917..254.487 rows=12,433 loops=1)

  • Group Key: rviph.vardiya_id, rviph.isemri_makine_plan_id
42. 8.123 218.459 ↓ 138.3 12,451 1

Sort (cost=4,869.91..4,870.13 rows=90 width=144) (actual time=215.905..218.459 rows=12,451 loops=1)

  • Sort Key: rviph.vardiya_id, rviph.isemri_makine_plan_id
  • Sort Method: quicksort Memory: 2135kB
43. 2.393 210.336 ↓ 138.3 12,451 1

Subquery Scan on rviph (cost=4,578.26..4,866.98 rows=90 width=144) (actual time=124.296..210.336 rows=12,451 loops=1)

44. 9.145 207.943 ↓ 138.3 12,451 1

Hash Join (cost=4,578.26..4,866.08 rows=90 width=878) (actual time=124.295..207.943 rows=12,451 loops=1)

  • Hash Cond: (p_1.personel_gorev_id = pg_1.personel_gorev_id)
45.          

CTE w_randiman_vrd_isemri_personel

46. 39.176 163.685 ↓ 1.0 12,451 1

GroupAggregate (cost=3,274.17..4,550.20 rows=12,449 width=208) (actual time=123.890..163.685 rows=12,451 loops=1)

  • Group Key: rvip_1.vardiya_id, vi_2.isemri_makine_plan_id, rvip_1.personel_id, rvip_1.personel_vardiya_grup_id, rvip_1.sayac_birim_id, rvip_1.birim_id
47. 11.858 124.509 ↓ 1.0 12,490 1

Sort (cost=3,274.17..3,305.30 rows=12,449 width=106) (actual time=123.871..124.509 rows=12,490 loops=1)

  • Sort Key: rvip_1.vardiya_id, vi_2.isemri_makine_plan_id, rvip_1.personel_id, rvip_1.personel_vardiya_grup_id, rvip_1.sayac_birim_id, rvip_1.birim_id
  • Sort Method: quicksort Memory: 2147kB
48. 5.935 112.651 ↓ 1.0 12,490 1

Hash Join (cost=1,727.53..2,427.41 rows=12,449 width=106) (actual time=93.604..112.651 rows=12,490 loops=1)

  • Hash Cond: (vvi_1.veri_isemri_id = vi_2.veri_isemri_id)
49. 6.297 78.332 ↓ 1.0 12,490 1

Hash Join (cost=1,514.28..2,181.45 rows=12,449 width=106) (actual time=65.191..78.332 rows=12,490 loops=1)

  • Hash Cond: (rvip_1.veri_vrd_isemri_id = vvi_1.veri_vrd_isemri_id)
50. 7.405 7.405 ↓ 1.0 12,490 1

Seq Scan on randiman_vrd_isemri_personel rvip_1 (cost=0.00..634.49 rows=12,449 width=106) (actual time=0.027..7.405 rows=12,490 loops=1)

51. 14.285 64.630 ↑ 1.1 39,990 1

Hash (cost=969.68..969.68 rows=43,568 width=8) (actual time=64.630..64.630 rows=39,990 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2075kB
52. 50.345 50.345 ↑ 1.1 39,990 1

Seq Scan on veri_vrd_isemri vvi_1 (cost=0.00..969.68 rows=43,568 width=8) (actual time=0.030..50.345 rows=39,990 loops=1)

53. 1.918 28.384 ↑ 1.1 4,119 1

Hash (cost=158.11..158.11 rows=4,411 width=8) (actual time=28.384..28.384 rows=4,119 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 225kB
54. 26.466 26.466 ↑ 1.1 4,119 1

Seq Scan on veri_isemri vi_2 (cost=0.00..158.11 rows=4,411 width=8) (actual time=0.023..26.466 rows=4,119 loops=1)

55. 6.743 198.751 ↓ 138.3 12,451 1

Nested Loop (cost=26.93..314.43 rows=90 width=148) (actual time=124.228..198.751 rows=12,451 loops=1)

  • Join Filter: (v_2.vardiya_zaman_id = vz_2.vardiya_zaman_id)
  • Rows Removed by Join Filter: 12538
56. 4.814 192.008 ↓ 138.3 12,451 1

Hash Join (cost=26.93..310.02 rows=90 width=152) (actual time=124.213..192.008 rows=12,451 loops=1)

  • Hash Cond: (wrvip_2.vardiya_id = v_2.vardiya_id)
57. 4.514 187.012 ↓ 138.3 12,451 1

Hash Join (cost=5.23..288.08 rows=90 width=148) (actual time=124.019..187.012 rows=12,451 loops=1)

  • Hash Cond: (wrvip_2.personel_id = p_1.personel_id)
58. 6.815 182.471 ↓ 66.6 12,451 1

Hash Join (cost=1.07..283.42 rows=187 width=148) (actual time=123.934..182.471 rows=12,451 loops=1)

  • Hash Cond: (wrvip_2.personel_vardiya_grup_id = pvg_1.personel_vardiya_grup_id)
59. 175.638 175.638 ↓ 1.0 12,451 1

CTE Scan on w_randiman_vrd_isemri_personel wrvip_2 (cost=0.00..248.98 rows=12,449 width=160) (actual time=123.895..175.638 rows=12,451 loops=1)

60. 0.004 0.018 ↓ 1.3 4 1

Hash (cost=1.03..1.03 rows=3 width=4) (actual time=0.018..0.018 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
61. 0.014 0.014 ↓ 1.3 4 1

Seq Scan on personel_vardiya_gruplari pvg_1 (cost=0.00..1.03 rows=3 width=4) (actual time=0.013..0.014 rows=4 loops=1)

62. 0.009 0.027 ↑ 2.0 48 1

Hash (cost=2.96..2.96 rows=96 width=8) (actual time=0.027..0.027 rows=48 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
63. 0.018 0.018 ↑ 2.0 48 1

Seq Scan on personeller p_1 (cost=0.00..2.96 rows=96 width=8) (actual time=0.009..0.018 rows=48 loops=1)

64. 0.072 0.182 ↓ 1.0 630 1

Hash (cost=14.09..14.09 rows=609 width=8) (actual time=0.182..0.182 rows=630 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
65. 0.110 0.110 ↓ 1.0 630 1

Seq Scan on vardiyalar v_2 (cost=0.00..14.09 rows=609 width=8) (actual time=0.009..0.110 rows=630 loops=1)

66. 0.000 0.000 ↑ 1.5 2 12,451

Materialize (cost=0.00..1.04 rows=3 width=4) (actual time=0.000..0.000 rows=2 loops=12,451)

67. 0.007 0.007 ↑ 1.0 3 1

Seq Scan on vardiya_zamanlari vz_2 (cost=0.00..1.03 rows=3 width=4) (actual time=0.006..0.007 rows=3 loops=1)

68. 0.008 0.047 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=4) (actual time=0.047..0.047 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
69. 0.039 0.039 ↑ 1.0 6 1

Seq Scan on personel_gorevleri pg_1 (cost=0.00..1.06 rows=6 width=4) (actual time=0.034..0.039 rows=6 loops=1)

70.          

CTE w_devir_hesap_tipleri

71. 0.062 0.222 ↓ 1.0 72 1

Hash Join (cost=2.16..5.00 rows=71 width=20) (actual time=0.081..0.222 rows=72 loops=1)

  • Hash Cond: (pms.birim_id = b_1.birim_id)
72. 0.061 0.145 ↓ 1.0 72 1

Hash Join (cost=1.04..3.54 rows=71 width=17) (actual time=0.048..0.145 rows=72 loops=1)

  • Hash Cond: (pms.devir_hesap_tip_id = dht.devir_hesap_tip_id)
73. 0.066 0.066 ↓ 1.0 72 1

Seq Scan on port_makine_sayac pms (cost=0.00..1.91 rows=71 width=12) (actual time=0.016..0.066 rows=72 loops=1)

  • Filter: (calisiyor_bilgisi_alinacak AND (sayac_tip_id = 1))
  • Rows Removed by Filter: 1
74. 0.006 0.018 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=9) (actual time=0.018..0.018 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
75. 0.012 0.012 ↑ 1.0 2 1

Seq Scan on devir_hesap_tipleri dht (cost=0.00..1.02 rows=2 width=9) (actual time=0.010..0.012 rows=2 loops=1)

76. 0.004 0.015 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=7) (actual time=0.015..0.015 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
77. 0.011 0.011 ↑ 1.0 5 1

Seq Scan on birimler b_1 (cost=0.00..1.05 rows=5 width=7) (actual time=0.009..0.011 rows=5 loops=1)

78. 174.905 13,614.552 ↑ 1.1 463 714

Hash Left Join (cost=23.28..1,091.59 rows=490 width=158) (actual time=15.758..19.068 rows=463 loops=714)

  • Hash Cond: (wrvi.birim_id = b.birim_id)
79. 209.879 13,439.622 ↑ 1.1 463 714

Hash Left Join (cost=22.16..1,089.17 rows=490 width=159) (actual time=15.757..18.823 rows=463 loops=714)

  • Hash Cond: (wrvi.sayac_birim_id = sb.birim_id)
80. 144.942 13,229.706 ↑ 1.1 463 714

Nested Loop (cost=21.05..1,086.75 rows=490 width=160) (actual time=15.755..18.529 rows=463 loops=714)

81. 145.639 12,093.018 ↑ 1.1 463 714

Hash Join (cost=20.77..939.45 rows=490 width=160) (actual time=15.741..16.937 rows=463 loops=714)

  • Hash Cond: (v_1.vardiya_zaman_id = vz_1.vardiya_zaman_id)
82. 168.181 11,947.362 ↑ 1.1 463 714

Hash Join (cost=19.70..935.28 rows=490 width=164) (actual time=15.740..16.733 rows=463 loops=714)

  • Hash Cond: (wrvi.makine_id = wdht.makine_id)
83. 3,708.231 11,778.858 ↑ 3.0 463 714

Hash Join (cost=17.40..922.91 rows=1,379 width=168) (actual time=15.738..16.497 rows=463 loops=714)

  • Hash Cond: (wrvi.vardiya_id = v_1.vardiya_id)
84. 8,070.342 8,070.342 ↑ 1.0 39,954 714

CTE Scan on w_randiman_vrd_isemri wrvi (cost=0.00..799.80 rows=39,990 width=156) (actual time=0.381..11.303 rows=39,954 loops=714)

85. 0.019 0.285 ↑ 1.0 21 1

Hash (cost=17.13..17.13 rows=21 width=12) (actual time=0.285..0.285 rows=21 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
86. 0.266 0.266 ↑ 1.0 21 1

Seq Scan on vardiyalar v_1 (cost=0.00..17.13 rows=21 width=12) (actual time=0.236..0.266 rows=21 loops=1)

  • Filter: ((yil = 2019) AND (hafta = 48))
  • Rows Removed by Filter: 609
87. 0.020 0.323 ↓ 1.0 72 1

Hash (cost=1.42..1.42 rows=71 width=4) (actual time=0.323..0.323 rows=72 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
88. 0.303 0.303 ↓ 1.0 72 1

CTE Scan on w_devir_hesap_tipleri wdht (cost=0.00..1.42 rows=71 width=4) (actual time=0.088..0.303 rows=72 loops=1)

89. 0.006 0.017 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=4) (actual time=0.017..0.017 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
90. 0.011 0.011 ↑ 1.0 3 1

Seq Scan on vardiya_zamanlari vz_1 (cost=0.00..1.03 rows=3 width=4) (actual time=0.010..0.011 rows=3 loops=1)

91. 991.746 991.746 ↑ 1.0 1 330,582

Index Only Scan using pk_isemri_makine_plan on isemri_makine_plan imp_1 (cost=0.28..0.30 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=330,582)

  • Index Cond: (isemri_makine_plan_id = wrvi.isemri_makine_plan_id)
  • Heap Fetches: 326298
92. 0.011 0.037 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=7) (actual time=0.037..0.037 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
93. 0.026 0.026 ↑ 1.0 5 1

Seq Scan on birimler sb (cost=0.00..1.05 rows=5 width=7) (actual time=0.023..0.026 rows=5 loops=1)

94. 0.007 0.025 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=7) (actual time=0.025..0.025 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
95. 0.018 0.018 ↑ 1.0 5 1

Seq Scan on birimler b (cost=0.00..1.05 rows=5 width=7) (actual time=0.014..0.018 rows=5 loops=1)

96. 2.459 266.786 ↓ 138.1 12,433 1

Hash (cost=1.80..1.80 rows=90 width=8) (actual time=266.785..266.786 rows=12,433 loops=1)

  • Buckets: 16384 (originally 1024) Batches: 1 (originally 1) Memory Usage: 614kB
97. 264.327 264.327 ↓ 138.1 12,433 1

CTE Scan on w_randiman_vrd_isemri_personel wrvip_1 (cost=0.00..1.80 rows=90 width=8) (actual time=215.920..264.327 rows=12,433 loops=1)

98. 0.075 0.075 ↑ 1.0 1 25

Index Scan using pk_isemri_makine_plan on isemri_makine_plan imp (cost=0.28..1.15 rows=1 width=48) (actual time=0.003..0.003 rows=1 loops=25)

  • Index Cond: (isemri_makine_plan_id = wrvi.isemri_makine_plan_id)
99. 0.125 0.125 ↑ 1.0 1 25

Index Scan using pk_isemri_rota on isemri_rota ir (cost=0.28..0.36 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=25)

  • Index Cond: (isemri_rota_id = imp.isemri_rota_id)
100. 0.125 0.125 ↑ 1.0 1 25

Index Scan using pk_isemri on isemri i (cost=0.28..0.37 rows=1 width=35) (actual time=0.005..0.005 rows=1 loops=25)

  • Index Cond: (isemri_id = ir.isemri_id)
101. 0.200 0.200 ↑ 1.0 1 25

Index Scan using pk_urunler on urunler u (cost=0.29..0.75 rows=1 width=45) (actual time=0.008..0.008 rows=1 loops=25)

  • Index Cond: (urun_id = i.urun_id)
102. 0.050 0.050 ↑ 1.0 1 25

Index Scan using pk_makineler on makineler m (cost=0.14..0.16 rows=1 width=27) (actual time=0.002..0.002 rows=1 loops=25)

  • Index Cond: (makine_id = imp.makine_id)
103. 0.125 0.125 ↑ 1.0 1 25

Index Scan using pk_isemri_makine_plan_durum on isemri_makine_plan_durum impd (cost=0.13..0.15 rows=1 width=13) (actual time=0.005..0.005 rows=1 loops=25)

  • Index Cond: (isemri_makine_plan_durum_id = imp.isemri_makine_plan_durum_id)
Planning time : 24.542 ms
Execution time : 14,741.078 ms