explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fXcw

Settings
# exclusive inclusive rows x rows loops node
1. 0.143 36,719.514 ↑ 1.0 101 1

Limit (cost=0.00..0.00 rows=101 width=226) (actual time=757.680..36,719.514 rows=101 loops=1)

2. 0.316 36,719.371 ↑ 2,009,751,134,711,338,240.0 101 1

Nested Loop Left Join (cost=0.00..4,392,426,949,275,259.50 rows=202,984,864,605,845,159,936 width=226) (actual time=757.679..36,719.371 rows=101 loops=1)

3. 0.877 36,702.592 ↑ 3,736,296,252.9 101 1

Nested Loop (cost=0.00..106,558,860,852.34 rows=377,365,921,545 width=226) (actual time=757.616..36,702.592 rows=101 loops=1)

4. 17,751.190 36,690.302 ↑ 72,857.6 101 1

Nested Loop Left Join (cost=0.00..106,267,693,913.67 rows=7,358,617 width=226) (actual time=757.580..36,690.302 rows=101 loops=1)

  • Join Filter: (property_p5.parent_id = operation.id)
  • Rows Removed by Join Filter: 77151981
5. 0.069 0.198 ↑ 72,857.6 101 1

Append (cost=0.00..230,381.16 rows=7,358,617 width=226) (actual time=0.009..0.198 rows=101 loops=1)

6. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on operation (cost=0.00..0.00 rows=1 width=320) (actual time=0.003..0.004 rows=0 loops=1)

7. 0.125 0.125 ↑ 4,654.6 101 1

Seq Scan on operation_s0 (cost=0.00..14,982.19 rows=470,119 width=209) (actual time=0.006..0.125 rows=101 loops=1)

8. 0.000 0.000 ↓ 0.0 0

Seq Scan on operation_s1 (cost=0.00..7,478.91 rows=248,591 width=214) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Seq Scan on operation_s10 (cost=0.00..18,995.47 rows=609,147 width=274) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Seq Scan on operation_s11 (cost=0.00..2,793.01 rows=84,101 width=215) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Seq Scan on operation_s12 (cost=0.00..6,505.87 rows=212,987 width=302) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Seq Scan on operation_s13 (cost=0.00..25,670.19 rows=873,019 width=220) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Seq Scan on operation_s14 (cost=0.00..3,343.80 rows=98,380 width=175) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Seq Scan on operation_s15 (cost=0.00..1,441.11 rows=46,011 width=302) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Seq Scan on operation_s16 (cost=0.00..5,106.44 rows=170,644 width=289) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Seq Scan on operation_s17 (cost=0.00..4,122.29 rows=122,629 width=299) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Seq Scan on operation_s18 (cost=0.00..5,449.43 rows=168,643 width=274) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Seq Scan on operation_s19 (cost=0.00..3,533.16 rows=118,616 width=275) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Seq Scan on operation_s2 (cost=0.00..1,889.83 rows=63,083 width=274) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Seq Scan on operation_s3 (cost=0.00..29,322.87 rows=885,787 width=219) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Seq Scan on operation_s4 (cost=0.00..17,376.42 rows=557,542 width=273) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Seq Scan on operation_s5 (cost=0.00..19,529.66 rows=569,566 width=224) (never executed)

23. 0.000 0.000 ↓ 0.0 0

Seq Scan on operation_s6 (cost=0.00..5,999.08 rows=196,208 width=191) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Seq Scan on operation_s7 (cost=0.00..2,738.37 rows=86,437 width=268) (never executed)

25. 0.000 0.000 ↓ 0.0 0

Seq Scan on operation_s8 (cost=0.00..948.82 rows=31,282 width=275) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Seq Scan on operation_s9 (cost=0.00..53,154.24 rows=1,745,824 width=179) (never executed)

27. 18,712.871 18,938.914 ↓ 1.0 763,881 101

Materialize (cost=0.00..24,640.23 rows=763,815 width=8) (actual time=0.004..187.514 rows=763,881 loops=101)

28. 226.043 226.043 ↓ 1.0 763,881 1

Seq Scan on property_p5 (cost=0.00..17,837.15 rows=763,815 width=8) (actual time=0.005..226.043 rows=763,881 loops=1)

29. 2.193 11.413 ↑ 21.0 1 101

Append (cost=0.00..39.36 rows=21 width=4) (actual time=0.026..0.113 rows=1 loops=101)

30. 0.101 0.101 ↓ 0.0 0 101

Seq Scan on device (cost=0.00..0.00 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=101)

  • Filter: (operation.device_id = device_id)
31. 1.919 1.919 ↑ 1.0 1 101

Index Only Scan using device_s0_pkey on device_s0 (cost=0.42..2.03 rows=1 width=4) (actual time=0.019..0.019 rows=1 loops=101)

  • Index Cond: (device_id = operation.device_id)
  • Heap Fetches: 101
32. 0.500 0.500 ↓ 0.0 0 100

Index Only Scan using device_s1_pkey on device_s1 (cost=0.42..2.03 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=100)

  • Index Cond: (device_id = operation.device_id)
  • Heap Fetches: 0
33. 0.400 0.400 ↓ 0.0 0 100

Index Only Scan using device_s10_pkey on device_s10 (cost=0.42..2.05 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (device_id = operation.device_id)
  • Heap Fetches: 0
34. 0.300 0.300 ↓ 0.0 0 100

Index Only Scan using device_s11_pkey on device_s11 (cost=0.29..1.87 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=100)

  • Index Cond: (device_id = operation.device_id)
  • Heap Fetches: 0
35. 0.400 0.400 ↓ 0.0 0 100

Index Only Scan using device_s12_pkey on device_s12 (cost=0.42..2.02 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (device_id = operation.device_id)
  • Heap Fetches: 0
36. 0.400 0.400 ↓ 0.0 0 100

Index Only Scan using device_s13_pkey on device_s13 (cost=0.42..2.06 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (device_id = operation.device_id)
  • Heap Fetches: 0
37. 0.300 0.300 ↓ 0.0 0 100

Index Only Scan using device_s14_pkey on device_s14 (cost=0.29..1.88 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=100)

  • Index Cond: (device_id = operation.device_id)
  • Heap Fetches: 0
38. 0.300 0.300 ↓ 0.0 0 100

Index Only Scan using device_s15_pkey on device_s15 (cost=0.29..1.86 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=100)

  • Index Cond: (device_id = operation.device_id)
  • Heap Fetches: 0
39. 0.400 0.400 ↓ 0.0 0 100

Index Only Scan using device_s16_pkey on device_s16 (cost=0.42..2.02 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (device_id = operation.device_id)
  • Heap Fetches: 0
40. 0.400 0.400 ↓ 0.0 0 100

Index Only Scan using device_s17_pkey on device_s17 (cost=0.42..2.01 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (device_id = operation.device_id)
  • Heap Fetches: 0
41. 0.400 0.400 ↓ 0.0 0 100

Index Only Scan using device_s18_pkey on device_s18 (cost=0.42..2.01 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (device_id = operation.device_id)
  • Heap Fetches: 0
42. 0.400 0.400 ↓ 0.0 0 100

Index Only Scan using device_s19_pkey on device_s19 (cost=0.42..2.01 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (device_id = operation.device_id)
  • Heap Fetches: 0
43. 0.300 0.300 ↓ 0.0 0 100

Index Only Scan using device_s2_pkey on device_s2 (cost=0.29..1.88 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=100)

  • Index Cond: (device_id = operation.device_id)
  • Heap Fetches: 0
44. 0.400 0.400 ↓ 0.0 0 100

Index Only Scan using device_s3_pkey on device_s3 (cost=0.42..2.05 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (device_id = operation.device_id)
  • Heap Fetches: 0
45. 0.400 0.400 ↓ 0.0 0 100

Index Only Scan using device_s4_pkey on device_s4 (cost=0.42..2.05 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (device_id = operation.device_id)
  • Heap Fetches: 0
46. 0.400 0.400 ↓ 0.0 0 100

Index Only Scan using device_s5_pkey on device_s5 (cost=0.42..1.92 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (device_id = operation.device_id)
  • Heap Fetches: 0
47. 0.400 0.400 ↓ 0.0 0 100

Index Only Scan using device_s6_pkey on device_s6 (cost=0.42..1.83 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (device_id = operation.device_id)
  • Heap Fetches: 0
48. 0.400 0.400 ↓ 0.0 0 100

Index Only Scan using device_s7_pkey on device_s7 (cost=0.42..2.00 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (device_id = operation.device_id)
  • Heap Fetches: 0
49. 0.300 0.300 ↓ 0.0 0 100

Index Only Scan using device_s8_pkey on device_s8 (cost=0.29..1.86 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=100)

  • Index Cond: (device_id = operation.device_id)
  • Heap Fetches: 0
50. 0.400 0.400 ↓ 0.0 0 100

Index Only Scan using device_s9_pkey on device_s9 (cost=0.43..1.92 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (device_id = operation.device_id)
  • Heap Fetches: 0
51. 0.673 16.463 ↓ 0.0 0 101

Nested Loop Left Join (cost=0.00..870.16 rows=1,076,926 width=8) (actual time=0.083..0.163 rows=0 loops=101)

52. 2.404 11.110 ↓ 0.0 0 101

Append (cost=0.00..35.64 rows=21 width=16) (actual time=0.072..0.110 rows=0 loops=101)

53. 0.000 0.000 ↓ 0.0 0 101

Seq Scan on switchdata (cost=0.00..0.00 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=101)

  • Filter: (operation_id = operation.id)
54. 0.606 0.606 ↓ 0.0 0 101

Index Scan using switchdata_s0_operation_id_idx on switchdata_s0 (cost=0.29..1.88 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=101)

  • Index Cond: (operation_id = operation.id)
55. 0.600 0.600 ↓ 0.0 0 100

Index Scan using switchdata_s1_operation_id_idx on switchdata_s1 (cost=0.42..2.00 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=100)

  • Index Cond: (operation_id = operation.id)
56. 0.500 0.500 ↓ 0.0 0 100

Index Scan using switchdata_s10_operation_id_idx on switchdata_s10 (cost=0.42..2.01 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=100)

  • Index Cond: (operation_id = operation.id)
57. 0.400 0.400 ↓ 0.0 0 100

Index Scan using switchdata_s11_operation_id_idx on switchdata_s11 (cost=0.28..1.70 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (operation_id = operation.id)
58. 0.500 0.500 ↓ 0.0 0 100

Index Scan using switchdata_s12_operation_id_idx on switchdata_s12 (cost=0.29..1.88 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=100)

  • Index Cond: (operation_id = operation.id)
59. 0.500 0.500 ↓ 0.0 0 100

Index Scan using switchdata_s13_operation_id_idx on switchdata_s13 (cost=0.29..1.87 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=100)

  • Index Cond: (operation_id = operation.id)
60. 0.400 0.400 ↓ 0.0 0 100

Index Scan using switchdata_s14_operation_id_idx on switchdata_s14 (cost=0.29..1.83 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (operation_id = operation.id)
61. 0.300 0.300 ↓ 0.0 0 100

Index Scan using switchdata_s15_operation_id_idx on switchdata_s15 (cost=0.15..0.17 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=100)

  • Index Cond: (operation_id = operation.id)
62. 0.400 0.400 ↓ 0.0 0 100

Index Scan using switchdata_s16_operation_id_idx on switchdata_s16 (cost=0.29..1.88 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (operation_id = operation.id)
63. 0.400 0.400 ↓ 0.0 0 100

Index Scan using switchdata_s17_operation_id_idx on switchdata_s17 (cost=0.29..1.86 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (operation_id = operation.id)
64. 0.400 0.400 ↓ 0.0 0 100

Index Scan using switchdata_s18_operation_id_idx on switchdata_s18 (cost=0.29..1.87 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (operation_id = operation.id)
65. 0.300 0.300 ↓ 0.0 0 100

Index Scan using switchdata_s19_operation_id_idx on switchdata_s19 (cost=0.29..1.83 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=100)

  • Index Cond: (operation_id = operation.id)
66. 0.400 0.400 ↓ 0.0 0 100

Index Scan using switchdata_s2_operation_id_idx on switchdata_s2 (cost=0.29..1.87 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (operation_id = operation.id)
67. 0.400 0.400 ↓ 0.0 0 100

Index Scan using switchdata_s3_operation_id_idx on switchdata_s3 (cost=0.28..1.61 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (operation_id = operation.id)
68. 0.500 0.500 ↓ 0.0 0 100

Index Scan using switchdata_s4_operation_id_idx on switchdata_s4 (cost=0.42..2.02 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=100)

  • Index Cond: (operation_id = operation.id)
69. 0.400 0.400 ↓ 0.0 0 100

Index Scan using switchdata_s5_operation_id_idx on switchdata_s5 (cost=0.29..1.83 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (operation_id = operation.id)
70. 0.400 0.400 ↓ 0.0 0 100

Index Scan using switchdata_s6_operation_id_idx on switchdata_s6 (cost=0.29..1.85 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (operation_id = operation.id)
71. 0.400 0.400 ↓ 0.0 0 100

Index Scan using switchdata_s7_operation_id_idx on switchdata_s7 (cost=0.29..1.85 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (operation_id = operation.id)
72. 0.400 0.400 ↓ 0.0 0 100

Index Scan using switchdata_s8_operation_id_idx on switchdata_s8 (cost=0.29..1.80 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=100)

  • Index Cond: (operation_id = operation.id)
73. 0.500 0.500 ↓ 0.0 0 100

Index Scan using switchdata_s9_operation_id_idx on switchdata_s9 (cost=0.42..2.03 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=100)

  • Index Cond: (operation_id = operation.id)
74. 0.872 4.680 ↑ 21.0 1 39

Append (cost=0.00..39.53 rows=21 width=4) (actual time=0.010..0.120 rows=1 loops=39)

75. 0.000 0.000 ↓ 0.0 0 39

Seq Scan on device target_device_t (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=39)

  • Filter: (device_id = switchdata.target_device_id)
76. 0.312 0.312 ↑ 1.0 1 39

Index Only Scan using device_s0_pkey on device_s0 target_device_t_1 (cost=0.42..2.05 rows=1 width=4) (actual time=0.007..0.008 rows=1 loops=39)

  • Index Cond: (device_id = switchdata.target_device_id)
  • Heap Fetches: 39
77. 0.228 0.228 ↓ 0.0 0 38

Index Only Scan using device_s1_pkey on device_s1 target_device_t_2 (cost=0.42..2.03 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=38)

  • Index Cond: (device_id = switchdata.target_device_id)
  • Heap Fetches: 0
78. 0.190 0.190 ↓ 0.0 0 38

Index Only Scan using device_s10_pkey on device_s10 target_device_t_3 (cost=0.42..2.07 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=38)

  • Index Cond: (device_id = switchdata.target_device_id)
  • Heap Fetches: 0
79. 0.152 0.152 ↓ 0.0 0 38

Index Only Scan using device_s11_pkey on device_s11 target_device_t_4 (cost=0.29..1.87 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=38)

  • Index Cond: (device_id = switchdata.target_device_id)
  • Heap Fetches: 0
80. 0.190 0.190 ↓ 0.0 0 38

Index Only Scan using device_s12_pkey on device_s12 target_device_t_5 (cost=0.42..2.03 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=38)

  • Index Cond: (device_id = switchdata.target_device_id)
  • Heap Fetches: 0
81. 0.190 0.190 ↓ 0.0 0 38

Index Only Scan using device_s13_pkey on device_s13 target_device_t_6 (cost=0.42..2.07 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=38)

  • Index Cond: (device_id = switchdata.target_device_id)
  • Heap Fetches: 0
82. 0.152 0.152 ↓ 0.0 0 38

Index Only Scan using device_s14_pkey on device_s14 target_device_t_7 (cost=0.29..1.88 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=38)

  • Index Cond: (device_id = switchdata.target_device_id)
  • Heap Fetches: 0
83. 0.190 0.190 ↓ 0.0 0 38

Index Only Scan using device_s15_pkey on device_s15 target_device_t_8 (cost=0.29..1.86 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=38)

  • Index Cond: (device_id = switchdata.target_device_id)
  • Heap Fetches: 0
84. 0.190 0.190 ↓ 0.0 0 38

Index Only Scan using device_s16_pkey on device_s16 target_device_t_9 (cost=0.42..2.02 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=38)

  • Index Cond: (device_id = switchdata.target_device_id)
  • Heap Fetches: 0
85. 0.190 0.190 ↓ 0.0 0 38

Index Only Scan using device_s17_pkey on device_s17 target_device_t_10 (cost=0.42..2.01 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=38)

  • Index Cond: (device_id = switchdata.target_device_id)
  • Heap Fetches: 0
86. 0.190 0.190 ↓ 0.0 0 38

Index Only Scan using device_s18_pkey on device_s18 target_device_t_11 (cost=0.42..2.02 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=38)

  • Index Cond: (device_id = switchdata.target_device_id)
  • Heap Fetches: 0
87. 0.190 0.190 ↓ 0.0 0 38

Index Only Scan using device_s19_pkey on device_s19 target_device_t_12 (cost=0.42..2.01 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=38)

  • Index Cond: (device_id = switchdata.target_device_id)
  • Heap Fetches: 0
88. 0.152 0.152 ↓ 0.0 0 38

Index Only Scan using device_s2_pkey on device_s2 target_device_t_13 (cost=0.29..1.88 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=38)

  • Index Cond: (device_id = switchdata.target_device_id)
  • Heap Fetches: 0
89. 0.190 0.190 ↓ 0.0 0 38

Index Only Scan using device_s3_pkey on device_s3 target_device_t_14 (cost=0.42..2.07 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=38)

  • Index Cond: (device_id = switchdata.target_device_id)
  • Heap Fetches: 0
90. 0.190 0.190 ↓ 0.0 0 38

Index Only Scan using device_s4_pkey on device_s4 target_device_t_15 (cost=0.42..2.07 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=38)

  • Index Cond: (device_id = switchdata.target_device_id)
  • Heap Fetches: 0
91. 0.190 0.190 ↓ 0.0 0 38

Index Only Scan using device_s5_pkey on device_s5 target_device_t_16 (cost=0.42..1.93 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=38)

  • Index Cond: (device_id = switchdata.target_device_id)
  • Heap Fetches: 0
92. 0.190 0.190 ↓ 0.0 0 38

Index Only Scan using device_s6_pkey on device_s6 target_device_t_17 (cost=0.42..1.84 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=38)

  • Index Cond: (device_id = switchdata.target_device_id)
  • Heap Fetches: 0
93. 0.190 0.190 ↓ 0.0 0 38

Index Only Scan using device_s7_pkey on device_s7 target_device_t_18 (cost=0.42..2.01 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=38)

  • Index Cond: (device_id = switchdata.target_device_id)
  • Heap Fetches: 0
94. 0.152 0.152 ↓ 0.0 0 38

Index Only Scan using device_s8_pkey on device_s8 target_device_t_19 (cost=0.29..1.86 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=38)

  • Index Cond: (device_id = switchdata.target_device_id)
  • Heap Fetches: 0
95. 0.190 0.190 ↓ 0.0 0 38

Index Only Scan using device_s9_pkey on device_s9 target_device_t_20 (cost=0.43..1.96 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=38)

  • Index Cond: (device_id = switchdata.target_device_id)
  • Heap Fetches: 0
Planning time : 4.776 ms
Execution time : 36,722.474 ms