explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b7NR

Settings
# exclusive inclusive rows x rows loops node
1. 0.236 2,300.584 ↑ 1.0 1,000 1

Limit (cost=1,074.55..46,230.14 rows=1,000 width=395) (actual time=620.413..2,300.584 rows=1,000 loops=1)

2. 6.172 2,300.348 ↑ 147.8 1,000 1

Nested Loop Left Join (cost=1,074.55..6,673,942.15 rows=147,775 width=395) (actual time=620.412..2,300.348 rows=1,000 loops=1)

3. 1.157 2,287.406 ↑ 147.8 1,000 1

Nested Loop Left Join (cost=1,074.27..4,115,782.44 rows=147,775 width=622) (actual time=620.354..2,287.406 rows=1,000 loops=1)

4. 1.347 2,284.249 ↑ 147.8 1,000 1

Nested Loop Left Join (cost=1,073.98..4,062,221.13 rows=147,775 width=622) (actual time=620.342..2,284.249 rows=1,000 loops=1)

5. 1.361 2,280.902 ↑ 147.8 1,000 1

Nested Loop Left Join (cost=1,073.70..4,017,476.86 rows=147,775 width=622) (actual time=620.328..2,280.902 rows=1,000 loops=1)

6. 0.682 2,274.541 ↑ 147.8 1,000 1

Nested Loop Left Join (cost=1,073.26..3,940,497.12 rows=147,775 width=622) (actual time=620.301..2,274.541 rows=1,000 loops=1)

7. 1.328 2,271.859 ↑ 147.8 1,000 1

Nested Loop (cost=1,072.98..3,895,419.50 rows=147,775 width=606) (actual time=620.289..2,271.859 rows=1,000 loops=1)

8. 1.476 2,269.531 ↑ 147.8 1,000 1

Nested Loop (cost=1,072.83..3,852,642.18 rows=147,775 width=608) (actual time=620.271..2,269.531 rows=1,000 loops=1)

9. 0.648 2,267.055 ↑ 147.8 1,000 1

Nested Loop (cost=1,072.68..3,828,264.43 rows=147,775 width=547) (actual time=620.262..2,267.055 rows=1,000 loops=1)

10. 3.505 2,264.407 ↑ 147.8 1,000 1

Nested Loop Left Join (cost=1,072.54..3,803,889.08 rows=147,775 width=479) (actual time=620.251..2,264.407 rows=1,000 loops=1)

  • Join Filter: (bs.id = COALESCE(bso.seria_id, bso2.seria_id))
  • Rows Removed by Join Filter: 40346
11. 0.876 2,258.902 ↑ 147.8 1,000 1

Nested Loop Left Join (cost=1,035.54..3,712,968.43 rows=147,775 width=455) (actual time=620.178..2,258.902 rows=1,000 loops=1)

12. 0.842 2,258.026 ↑ 147.8 1,000 1

Nested Loop Left Join (cost=1,035.10..3,398,479.39 rows=147,775 width=451) (actual time=620.172..2,258.026 rows=1,000 loops=1)

13. 0.912 2,257.184 ↑ 147.8 1,000 1

Nested Loop Left Join (cost=1,034.68..3,326,571.13 rows=147,775 width=452) (actual time=620.167..2,257.184 rows=1,000 loops=1)

14. 0.787 2,256.272 ↑ 147.8 1,000 1

Nested Loop Left Join (cost=1,034.26..3,254,736.50 rows=147,775 width=444) (actual time=620.162..2,256.272 rows=1,000 loops=1)

15. 1.228 2,249.485 ↑ 147.8 1,000 1

Nested Loop (cost=1,033.83..3,182,653.93 rows=147,775 width=433) (actual time=620.149..2,249.485 rows=1,000 loops=1)

16. 1.450 2,244.257 ↑ 147.8 1,000 1

Nested Loop (cost=1,033.40..3,023,216.25 rows=147,775 width=433) (actual time=620.105..2,244.257 rows=1,000 loops=1)

17. 0.838 2,241.807 ↑ 147.8 1,000 1

Nested Loop (cost=1,033.25..2,996,831.77 rows=147,775 width=437) (actual time=620.066..2,241.807 rows=1,000 loops=1)

18. 1.347 2,237.951 ↑ 146.9 1,006 1

Nested Loop Left Join (cost=1,032.97..2,777,870.86 rows=147,775 width=433) (actual time=620.044..2,237.951 rows=1,006 loops=1)

  • Join Filter: (cg.sector_id = gs."foreignID")
  • Rows Removed by Join Filter: 3073
19. 1.110 2,230.568 ↑ 146.9 1,006 1

Nested Loop Left Join (cost=1,032.54..2,697,168.21 rows=147,775 width=441) (actual time=620.025..2,230.568 rows=1,006 loops=1)

20. 1.100 2,225.434 ↑ 146.9 1,006 1

Nested Loop Left Join (cost=1,032.12..2,613,761.81 rows=147,775 width=412) (actual time=619.991..2,225.434 rows=1,006 loops=1)

21. 0.899 2,220.310 ↑ 145.1 1,006 1

Nested Loop Left Join (cost=1,031.70..2,548,271.02 rows=145,935 width=345) (actual time=619.953..2,220.310 rows=1,006 loops=1)

22. 0.909 2,219.411 ↑ 145.1 1,006 1

Nested Loop Left Join (cost=1,031.28..2,471,963.30 rows=145,935 width=339) (actual time=619.946..2,219.411 rows=1,006 loops=1)

23. 0.844 2,218.502 ↑ 145.1 1,006 1

Nested Loop Left Join (cost=1,030.86..2,392,562.33 rows=145,935 width=274) (actual time=619.938..2,218.502 rows=1,006 loops=1)

24. 0.464 2,217.658 ↑ 145.1 1,006 1

Nested Loop Left Join (cost=1,030.59..2,349,796.99 rows=145,935 width=270) (actual time=619.932..2,217.658 rows=1,006 loops=1)

  • Join Filter: (erd.type = 4)
25. 1.657 2,214.176 ↑ 145.1 1,006 1

Nested Loop Left Join (cost=1,030.16..2,283,133.81 rows=145,935 width=230) (actual time=619.918..2,214.176 rows=1,006 loops=1)

26. 143.673 2,206.483 ↑ 145.1 1,006 1

Merge Left Join (cost=1,029.73..2,170,032.58 rows=145,935 width=217) (actual time=619.886..2,206.483 rows=1,006 loops=1)

  • Merge Cond: (er.order_id = dt.order_id)
  • Join Filter: ((erd.type = 1) AND (dt.ticket_id = erd.object_id))
  • Rows Removed by Join Filter: 2078
27. 0.000 401.957 ↑ 145.1 1,006 1

Gather Merge (cost=1,002.47..915,628.65 rows=145,935 width=205) (actual time=398.391..401.957 rows=1,006 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
28. 0.870 1,978.515 ↑ 110.4 551 3

Nested Loop Left Join (cost=2.44..897,784.11 rows=60,806 width=205) (actual time=333.253..659.505 rows=551 loops=3)

  • Join Filter: ((erd.type = 1) AND (tc.order_id = er.order_id))
  • Rows Removed by Join Filter: 2
29. 0.762 1,969.380 ↑ 110.4 551 3

Nested Loop Left Join (cost=2.01..866,282.08 rows=60,806 width=193) (actual time=333.223..656.460 rows=551 loops=3)

  • Join Filter: (er.id = erd_discount.er_id)
30. 2.861 1,958.700 ↑ 110.4 551 3

Nested Loop (cost=1.57..831,751.53 rows=60,806 width=193) (actual time=333.182..652.900 rows=551 loops=3)

31. 0.000 1,929.654 ↑ 12.0 1,746 3

Nested Loop Left Join (cost=1.14..811,870.46 rows=20,922 width=177) (actual time=203.325..643.218 rows=1,746 loops=3)

32. 458.786 1,919.271 ↑ 12.0 1,746 3

Nested Loop (cost=0.85..805,211.01 rows=20,922 width=48) (actual time=203.300..639.757 rows=1,746 loops=3)

33. 581.034 581.034 ↑ 4.9 293,150 3

Parallel Index Scan using epayment_record_order_id_inx on epayment_record er (cost=0.43..156,609.51 rows=1,435,070 width=32) (actual time=0.024..193.678 rows=293,150 loops=3)

34. 879.451 879.451 ↓ 0.0 0 879,451

Index Scan using epayment_record_status_log_er_id_type_idx on epayment_record_status_log ersl_accepted (cost=0.42..0.44 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=879,451)

  • Index Cond: ((er_id = er.id) AND (type = 'REFUND_ACCEPTED'::epayment_record_status_log_type))
35. 10.474 10.474 ↓ 0.0 0 5,237

Index Scan using refunds_requests_er_id_idx on refunds_requests rr (cost=0.29..0.31 rows=1 width=137) (actual time=0.001..0.002 rows=0 loops=5,237)

  • Index Cond: (er_id = er.id)
36. 26.185 26.185 ↓ 0.0 0 5,237

Index Scan using uniq_epayment_record_details on epayment_record_details erd (cost=0.43..0.81 rows=14 width=24) (actual time=0.005..0.005 rows=0 loops=5,237)

  • Index Cond: (er_id = er.id)
37. 9.918 9.918 ↓ 0.0 0 1,653

Index Scan using epayment_record_details_object_id_idx on epayment_record_details erd_discount (cost=0.43..0.56 rows=1 width=20) (actual time=0.006..0.006 rows=0 loops=1,653)

  • Index Cond: (erd.object_id = object_id)
  • Filter: (type = 10)
  • Rows Removed by Filter: 3
38. 8.265 8.265 ↑ 1.0 1 1,653

Index Scan using ticket_cart_pkey on ticket_cart tc (cost=0.43..0.50 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=1,653)

  • Index Cond: (id = erd.object_id)
39. 230.773 1,660.853 ↑ 6.8 1,807,755 1

Materialize (cost=27.26..1,213,864.48 rows=12,317,227 width=16) (actual time=1.126..1,660.853 rows=1,807,755 loops=1)

40. 193.712 1,430.080 ↑ 6.8 1,805,794 1

Merge Append (cost=27.26..1,183,071.41 rows=12,317,227 width=16) (actual time=1.122..1,430.080 rows=1,805,794 loops=1)

  • Sort Key: dt.order_id
41. 0.006 0.006 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_order_id on deleted_ticket dt (cost=0.12..8.14 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=1)

42. 40.507 40.507 ↑ 1.0 84,415 1

Index Scan using ix_deleted_ticket_201401_order_id on deleted_ticket_201401 dt_1 (cost=0.29..8,245.24 rows=84,415 width=16) (actual time=0.010..40.507 rows=84,415 loops=1)

43. 46.418 46.418 ↑ 1.0 91,848 1

Index Scan using ix_deleted_ticket_201402_order_id on deleted_ticket_201402 dt_2 (cost=0.29..4,907.16 rows=91,848 width=16) (actual time=0.012..46.418 rows=91,848 loops=1)

44. 46.033 46.033 ↑ 1.0 92,135 1

Index Scan using ix_deleted_ticket_201403_order_id on deleted_ticket_201403 dt_3 (cost=0.29..5,189.51 rows=92,135 width=16) (actual time=0.014..46.033 rows=92,135 loops=1)

45. 41.376 41.376 ↑ 1.0 78,409 1

Index Scan using ix_deleted_ticket_201404_order_id on deleted_ticket_201404 dt_4 (cost=0.29..4,225.61 rows=78,409 width=16) (actual time=0.012..41.376 rows=78,409 loops=1)

46. 119.939 119.939 ↑ 1.0 186,385 1

Index Scan using ix_deleted_ticket_201405_order_id on deleted_ticket_201405 dt_5 (cost=0.42..20,815.18 rows=186,385 width=16) (actual time=0.013..119.939 rows=186,385 loops=1)

47. 81.137 81.137 ↑ 1.0 141,320 1

Index Scan using ix_deleted_ticket_201406_order_id on deleted_ticket_201406 dt_6 (cost=0.42..8,971.57 rows=141,320 width=16) (actual time=0.018..81.137 rows=141,320 loops=1)

48. 55.442 55.442 ↑ 1.0 94,749 1

Index Scan using ix_deleted_ticket_201407_order_id on deleted_ticket_201407 dt_7 (cost=0.29..5,694.73 rows=94,749 width=16) (actual time=0.010..55.442 rows=94,749 loops=1)

49. 46.430 46.430 ↑ 1.0 79,077 1

Index Scan using ix_deleted_ticket_201408_order_id on deleted_ticket_201408 dt_8 (cost=0.29..5,212.85 rows=79,077 width=16) (actual time=0.010..46.430 rows=79,077 loops=1)

50. 80.084 80.084 ↑ 1.0 133,753 1

Index Scan using ix_deleted_ticket_201409_order_id on deleted_ticket_201409 dt_9 (cost=0.42..7,957.51 rows=133,753 width=16) (actual time=0.014..80.084 rows=133,753 loops=1)

51. 131.651 131.651 ↑ 1.0 161,250 1

Index Scan using ix_deleted_ticket_201410_order_id on deleted_ticket_201410 dt_10 (cost=0.42..17,900.09 rows=161,250 width=16) (actual time=0.016..131.651 rows=161,250 loops=1)

52. 156.735 156.735 ↑ 1.0 198,022 1

Index Scan using ix_deleted_ticket_201411_order_id on deleted_ticket_201411 dt_11 (cost=0.42..22,312.57 rows=198,022 width=16) (actual time=0.021..156.735 rows=198,022 loops=1)

53. 156.459 156.459 ↑ 1.0 198,046 1

Index Scan using ix_deleted_ticket_201412_order_id on deleted_ticket_201412 dt_12 (cost=0.42..23,278.30 rows=198,046 width=16) (actual time=0.013..156.459 rows=198,046 loops=1)

54. 120.831 120.831 ↑ 1.0 148,863 1

Index Scan using ix_deleted_ticket_201501_order_id on deleted_ticket_201501 dt_13 (cost=0.42..16,822.44 rows=148,863 width=16) (actual time=0.021..120.831 rows=148,863 loops=1)

55. 90.798 90.798 ↑ 1.6 104,410 1

Index Scan using ix_deleted_ticket_201502_order_id on deleted_ticket_201502 dt_14 (cost=0.42..18,080.11 rows=162,456 width=16) (actual time=0.028..90.798 rows=104,410 loops=1)

56. 11.502 11.502 ↑ 50.5 4,108 1

Index Scan using ix_deleted_ticket_201503_order_id on deleted_ticket_201503 dt_15 (cost=0.42..22,671.95 rows=207,602 width=16) (actual time=0.032..11.502 rows=4,108 loops=1)

57. 3.127 3.127 ↑ 119.1 1,351 1

Index Scan using ix_deleted_ticket_201504_order_id on deleted_ticket_201504 dt_16 (cost=0.42..17,884.80 rows=160,931 width=16) (actual time=0.025..3.127 rows=1,351 loops=1)

58. 1.232 1.232 ↑ 302.3 479 1

Index Scan using ix_deleted_ticket_201505_order_id on deleted_ticket_201505 dt_17 (cost=0.42..11,557.87 rows=144,787 width=16) (actual time=0.015..1.232 rows=479 loops=1)

59. 0.618 0.618 ↑ 575.1 219 1

Index Scan using ix_deleted_ticket_201506_order_id on deleted_ticket_201506 dt_18 (cost=0.42..7,549.84 rows=125,943 width=16) (actual time=0.027..0.618 rows=219 loops=1)

60. 0.850 0.850 ↑ 472.0 261 1

Index Scan using ix_deleted_ticket_201507_order_id on deleted_ticket_201507 dt_19 (cost=0.42..7,394.18 rows=123,193 width=16) (actual time=0.027..0.850 rows=261 loops=1)

61. 0.534 0.534 ↑ 598.1 195 1

Index Scan using ix_deleted_ticket_201508_order_id on deleted_ticket_201508 dt_20 (cost=0.42..7,131.33 rows=116,638 width=16) (actual time=0.025..0.534 rows=195 loops=1)

62. 0.710 0.710 ↑ 700.7 264 1

Index Scan using ix_deleted_ticket_201509_order_id on deleted_ticket_201509 dt_21 (cost=0.42..10,536.63 rows=184,975 width=16) (actual time=0.023..0.710 rows=264 loops=1)

63. 0.379 0.379 ↑ 3,002.9 138 1

Index Scan using ix_deleted_ticket_201510_order_id on deleted_ticket_201510 dt_22 (cost=0.42..22,136.65 rows=414,396 width=16) (actual time=0.024..0.379 rows=138 loops=1)

64. 0.090 0.090 ↑ 28,582.1 12 1

Index Scan using ix_deleted_ticket_201511_order_id on deleted_ticket_201511 dt_23 (cost=0.42..18,376.13 rows=342,985 width=16) (actual time=0.027..0.090 rows=12 loops=1)

65. 0.032 0.032 ↑ 95,369.0 3 1

Index Scan using ix_deleted_ticket_201512_order_id on deleted_ticket_201512 dt_24 (cost=0.42..15,148.24 rows=286,107 width=16) (actual time=0.019..0.032 rows=3 loops=1)

66. 0.022 0.022 ↑ 74,692.7 3 1

Index Scan using ix_deleted_ticket_201601_order_id on deleted_ticket_201601 dt_25 (cost=0.42..12,600.16 rows=224,078 width=16) (actual time=0.016..0.022 rows=3 loops=1)

67. 0.015 0.015 ↑ 287,859.0 1 1

Index Scan using ix_deleted_ticket_201602_order_id on deleted_ticket_201602 dt_26 (cost=0.42..16,929.68 rows=287,859 width=16) (actual time=0.015..0.015 rows=1 loops=1)

68. 0.038 0.038 ↑ 85,817.2 4 1

Index Scan using ix_deleted_ticket_201603_order_id on deleted_ticket_201603 dt_27 (cost=0.42..18,635.13 rows=343,269 width=16) (actual time=0.019..0.038 rows=4 loops=1)

69. 0.016 0.016 ↑ 169,288.0 1 1

Index Scan using ix_deleted_ticket_201604_order_id on deleted_ticket_201604 dt_28 (cost=0.42..8,904.40 rows=169,288 width=16) (actual time=0.016..0.016 rows=1 loops=1)

70. 0.015 0.015 ↑ 149,260.0 1 1

Index Scan using ix_deleted_ticket_201605_order_id on deleted_ticket_201605 dt_29 (cost=0.42..8,333.99 rows=149,260 width=16) (actual time=0.015..0.015 rows=1 loops=1)

71. 0.021 0.021 ↑ 70,839.5 2 1

Index Scan using ix_deleted_ticket_201606_order_id on deleted_ticket_201606 dt_30 (cost=0.42..8,146.76 rows=141,679 width=16) (actual time=0.014..0.021 rows=2 loops=1)

72. 0.019 0.019 ↑ 108,771.0 1 1

Index Scan using ix_deleted_ticket_201607_order_id on deleted_ticket_201607 dt_31 (cost=0.42..6,043.74 rows=108,771 width=16) (actual time=0.019..0.019 rows=1 loops=1)

73. 0.026 0.026 ↑ 54,024.5 2 1

Index Scan using ix_deleted_ticket_201608_order_id on deleted_ticket_201608 dt_32 (cost=0.42..5,957.52 rows=108,049 width=16) (actual time=0.014..0.026 rows=2 loops=1)

74. 0.028 0.028 ↑ 88,234.0 2 1

Index Scan using ix_deleted_ticket_201609_order_id on deleted_ticket_201609 dt_33 (cost=0.42..10,169.27 rows=176,468 width=16) (actual time=0.022..0.028 rows=2 loops=1)

75. 0.017 0.017 ↑ 226,010.0 1 1

Index Scan using ix_deleted_ticket_201610_order_id on deleted_ticket_201610 dt_34 (cost=0.42..12,313.32 rows=226,010 width=16) (actual time=0.017..0.017 rows=1 loops=1)

76. 0.019 0.019 ↑ 51,273.4 5 1

Index Scan using ix_deleted_ticket_201611_order_id on deleted_ticket_201611 dt_35 (cost=0.42..14,781.07 rows=256,367 width=16) (actual time=0.013..0.019 rows=5 loops=1)

77. 0.026 0.026 ↑ 153,578.0 1 1

Index Scan using ix_deleted_ticket_201612_order_id on deleted_ticket_201612 dt_36 (cost=0.42..8,623.87 rows=153,578 width=16) (actual time=0.026..0.026 rows=1 loops=1)

78. 0.012 0.012 ↑ 114,358.0 1 1

Index Scan using ix_deleted_ticket_201701_order_id on deleted_ticket_201701 dt_37 (cost=0.42..6,205.46 rows=114,358 width=16) (actual time=0.012..0.012 rows=1 loops=1)

79. 0.018 0.018 ↑ 239,197.0 1 1

Index Scan using ix_deleted_ticket_201702_order_id on deleted_ticket_201702 dt_38 (cost=0.42..12,656.21 rows=239,197 width=16) (actual time=0.018..0.018 rows=1 loops=1)

80. 0.014 0.014 ↑ 304,304.0 1 1

Index Scan using ix_deleted_ticket_201703_order_id on deleted_ticket_201703 dt_39 (cost=0.42..15,997.05 rows=304,304 width=16) (actual time=0.014..0.014 rows=1 loops=1)

81. 0.749 0.749 ↑ 140.2 1,733 1

Index Scan using ix_deleted_ticket_201704_order_id on deleted_ticket_201704 dt_40 (cost=0.42..21,120.12 rows=243,015 width=16) (actual time=0.017..0.749 rows=1,733 loops=1)

82. 0.026 0.026 ↑ 215,487.0 1 1

Index Scan using ix_deleted_ticket_201705_order_id on deleted_ticket_201705 dt_41 (cost=0.42..11,585.03 rows=215,487 width=16) (actual time=0.026..0.026 rows=1 loops=1)

83. 0.014 0.014 ↑ 228,754.0 1 1

Index Scan using ix_deleted_ticket_201706_order_id on deleted_ticket_201706 dt_42 (cost=0.42..12,601.73 rows=228,754 width=16) (actual time=0.014..0.014 rows=1 loops=1)

84. 1.939 1.939 ↑ 50.9 4,308 1

Index Scan using ix_deleted_ticket_201707_order_id on deleted_ticket_201707 dt_43 (cost=0.42..12,040.94 rows=219,369 width=16) (actual time=0.016..1.939 rows=4,308 loops=1)

85. 0.015 0.015 ↑ 197,978.0 1 1

Index Scan using ix_deleted_ticket_201708_order_id on deleted_ticket_201708 dt_44 (cost=0.42..10,611.41 rows=197,978 width=16) (actual time=0.015..0.015 rows=1 loops=1)

86. 0.049 0.049 ↑ 17,560.4 15 1

Index Scan using ix_deleted_ticket_201709_order_id on deleted_ticket_201709 dt_45 (cost=0.42..13,922.88 rows=263,406 width=16) (actual time=0.016..0.049 rows=15 loops=1)

87. 0.018 0.018 ↑ 391,597.0 1 1

Index Scan using ix_deleted_ticket_201710_order_id on deleted_ticket_201710 dt_46 (cost=0.42..21,110.62 rows=391,597 width=16) (actual time=0.018..0.018 rows=1 loops=1)

88. 0.015 0.015 ↑ 359,529.0 1 1

Index Scan using ix_deleted_ticket_201711_order_id on deleted_ticket_201711 dt_47 (cost=0.42..19,629.28 rows=359,529 width=16) (actual time=0.015..0.015 rows=1 loops=1)

89. 0.014 0.014 ↑ 213,348.0 1 1

Index Scan using ix_deleted_ticket_201712_order_id on deleted_ticket_201712 dt_48 (cost=0.42..11,837.39 rows=213,348 width=16) (actual time=0.014..0.014 rows=1 loops=1)

90. 0.020 0.020 ↑ 200,406.0 1 1

Index Scan using ix_deleted_ticket_201801_order_id on deleted_ticket_201801 dt_49 (cost=0.42..11,251.64 rows=200,406 width=16) (actual time=0.020..0.020 rows=1 loops=1)

91. 0.013 0.013 ↑ 265,461.0 1 1

Index Scan using ix_deleted_ticket_201802_order_id on deleted_ticket_201802 dt_50 (cost=0.42..14,650.59 rows=265,461 width=16) (actual time=0.013..0.013 rows=1 loops=1)

92. 0.017 0.017 ↑ 304,092.0 1 1

Index Scan using ix_deleted_ticket_201803_order_id on deleted_ticket_201803 dt_51 (cost=0.42..17,070.62 rows=304,092 width=16) (actual time=0.017..0.017 rows=1 loops=1)

93. 0.023 0.023 ↑ 169,737.0 1 1

Index Scan using ix_deleted_ticket_201804_order_id on deleted_ticket_201804 dt_52 (cost=0.42..9,543.88 rows=169,737 width=16) (actual time=0.023..0.023 rows=1 loops=1)

94. 0.020 0.020 ↑ 169,556.0 1 1

Index Scan using ix_deleted_ticket_201805_order_id on deleted_ticket_201805 dt_53 (cost=0.42..9,196.91 rows=169,556 width=16) (actual time=0.020..0.020 rows=1 loops=1)

95. 0.014 0.014 ↑ 223,326.0 1 1

Index Scan using ix_deleted_ticket_201806_order_id on deleted_ticket_201806 dt_54 (cost=0.42..18,142.09 rows=223,326 width=16) (actual time=0.014..0.014 rows=1 loops=1)

96. 0.084 0.084 ↑ 9,235.4 28 1

Index Scan using ix_deleted_ticket_201807_order_id on deleted_ticket_201807 dt_55 (cost=0.42..14,164.45 rows=258,591 width=16) (actual time=0.016..0.084 rows=28 loops=1)

97. 0.015 0.015 ↑ 257,807.0 1 1

Index Scan using ix_deleted_ticket_201808_order_id on deleted_ticket_201808 dt_56 (cost=0.42..13,785.53 rows=257,807 width=16) (actual time=0.015..0.015 rows=1 loops=1)

98. 0.014 0.014 ↑ 290,956.0 1 1

Index Scan using ix_deleted_ticket_201809_order_id on deleted_ticket_201809 dt_57 (cost=0.42..15,425.49 rows=290,956 width=16) (actual time=0.014..0.014 rows=1 loops=1)

99. 0.015 0.015 ↑ 371,039.0 1 1

Index Scan using ix_deleted_ticket_201810_order_id on deleted_ticket_201810 dt_58 (cost=0.42..19,569.48 rows=371,039 width=16) (actual time=0.015..0.015 rows=1 loops=1)

100. 0.012 0.012 ↑ 311,377.0 1 1

Index Scan using ix_deleted_ticket_201811_order_id on deleted_ticket_201811 dt_59 (cost=0.42..16,953.82 rows=311,377 width=16) (actual time=0.012..0.012 rows=1 loops=1)

101. 0.019 0.019 ↑ 144,188.0 1 1

Index Scan using ix_deleted_ticket_201812_order_id on deleted_ticket_201812 dt_60 (cost=0.42..7,764.67 rows=144,188 width=16) (actual time=0.019..0.019 rows=1 loops=1)

102. 0.016 0.016 ↑ 56,923.0 1 1

Index Scan using ix_deleted_ticket_201901_order_id on deleted_ticket_201901 dt_61 (cost=0.29..2,984.98 rows=56,923 width=16) (actual time=0.016..0.016 rows=1 loops=1)

103. 0.009 0.009 ↑ 264.0 1 1

Index Scan using ix_deleted_ticket_201902_order_id on deleted_ticket_201902 dt_62 (cost=0.15..20.95 rows=264 width=16) (actual time=0.009..0.009 rows=1 loops=1)

104. 0.006 0.006 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201903_order_id on deleted_ticket_201903 dt_63 (cost=0.14..45.64 rows=100 width=16) (actual time=0.006..0.006 rows=0 loops=1)

105. 0.006 0.006 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201904_order_id on deleted_ticket_201904 dt_64 (cost=0.14..45.64 rows=100 width=16) (actual time=0.006..0.006 rows=0 loops=1)

106. 6.036 6.036 ↑ 1.0 1 1,006

Index Scan using cultserv_gateway_pkey on cultserv_gateway cg (cost=0.44..0.78 rows=1 width=21) (actual time=0.006..0.006 rows=1 loops=1,006)

  • Index Cond: (id = COALESCE(tc.gw_ticket_id, dt.gw_ticket_id))
107. 3.018 3.018 ↓ 0.0 0 1,006

Index Scan using tickets_pkey on tickets at (cost=0.42..0.44 rows=1 width=48) (actual time=0.003..0.003 rows=0 loops=1,006)

  • Index Cond: (id = erd.object_id)
108. 0.000 0.000 ↓ 0.0 0 1,006

Index Scan using "GateWayName_pkey" on "GateWayName" gwn (cost=0.28..0.29 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=1,006)

  • Index Cond: (at.gateway_id = id)
109. 0.000 0.000 ↓ 0.0 0 1,006

Index Scan using subevents_pkey on subevents asub (cost=0.42..0.54 rows=1 width=89) (actual time=0.000..0.000 rows=0 loops=1,006)

  • Index Cond: ((gateway_id = at.gateway_id) AND (foreign_id = at.subevent_id))
110. 0.000 0.000 ↓ 0.0 0 1,006

Index Scan using sectors_pkey on sectors asec (cost=0.42..0.52 rows=1 width=54) (actual time=0.000..0.000 rows=0 loops=1,006)

  • Index Cond: ((gateway_id = at.gateway_id) AND (foreign_id = at.sector_id) AND (venue_configuration_id = at.venue_configuration_id))
111. 4.024 4.024 ↑ 1.0 1 1,006

Index Scan using cache_gateway_event_gateway_id_event_id_key on cache_gateway_event cge (cost=0.42..0.44 rows=1 width=71) (actual time=0.004..0.004 rows=1 loops=1,006)

  • Index Cond: (cg.event_id = event_id)
112. 4.024 4.024 ↑ 1.0 1 1,006

Index Scan using cache_gateway_sector_cache_gateway_event_id_sector_id_idx on cache_gateway_sector cgs (cost=0.42..0.55 rows=1 width=37) (actual time=0.004..0.004 rows=1 loops=1,006)

  • Index Cond: ((cache_gateway_event_id = cge.id) AND (sector_id = cg.sector_id))
113. 6.036 6.036 ↓ 4.0 4 1,006

Index Scan using "GatewaySector_foreignEventID_GateWayClassId_idx" on "GatewaySector" gs (cost=0.42..0.53 rows=1 width=16) (actual time=0.004..0.006 rows=4 loops=1,006)

  • Index Cond: ((cge.event_id = "foreignEventID") AND (cge.gateway_id = "GateWayClassId"))
114. 3.018 3.018 ↑ 1.0 1 1,006

Index Scan using hamster_pkey on hamster h (cost=0.28..1.48 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=1,006)

  • Index Cond: (id = COALESCE(cge.hamster_id, gwn.default_hamster))
115. 1.000 1.000 ↑ 1.0 1 1,000

Index Only Scan using hamster_closure_pkey on hamster_closure hc (cost=0.15..0.18 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1,000)

  • Index Cond: (id = h.closure_id)
  • Heap Fetches: 1000
116. 4.000 4.000 ↑ 1.0 1 1,000

Index Scan using "dateEvents_pkey" on "dateEvents" de (cost=0.42..1.08 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1,000)

  • Index Cond: (id = COALESCE((gs."eventID")::bigint, asub.dateevent_id))
117. 6.000 6.000 ↑ 1.0 1 1,000

Index Scan using bso_blank_gw_ticket_id_idx on bso_blank bso (cost=0.43..0.48 rows=1 width=15) (actual time=0.005..0.006 rows=1 loops=1,000)

  • Index Cond: (gw_ticket_id = cg.id)
118. 0.000 0.000 ↓ 0.0 0 1,000

Index Scan using ticket_printing_ticket_id_key on ticket_printing atp (cost=0.42..0.49 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Index Cond: (at.id = ticket_id)
119. 0.000 0.000 ↓ 0.0 0 1,000

Index Scan using blanks_pkey on blanks ab (cost=0.42..0.49 rows=1 width=15) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Index Cond: (id = atp.blank_id)
120. 0.000 0.000 ↓ 0.0 0 1,000

Index Scan using bso_blank_bso_seria_id_bso_id_idx on bso_blank bso2 (cost=0.43..2.12 rows=1 width=11) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Index Cond: (((bso_seria_id)::text = (ab.seria)::text) AND (bso_id = ab.number))
121. 1.933 2.000 ↑ 1.0 41 1,000

Materialize (cost=37.00..39.13 rows=41 width=36) (actual time=0.000..0.002 rows=41 loops=1,000)

122. 0.038 0.067 ↑ 1.0 41 1

Hash Left Join (cost=37.00..38.93 rows=41 width=36) (actual time=0.055..0.067 rows=41 loops=1)

  • Hash Cond: (bs.print_type = bspt.id)
123. 0.018 0.018 ↑ 1.0 41 1

Seq Scan on bso_seria bs (cost=0.00..1.41 rows=41 width=8) (actual time=0.015..0.018 rows=41 loops=1)

124. 0.005 0.011 ↑ 600.0 2 1

Hash (cost=22.00..22.00 rows=1,200 width=40) (actual time=0.011..0.011 rows=2 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
125. 0.006 0.006 ↑ 600.0 2 1

Seq Scan on bso_seria_print_type bspt (cost=0.00..22.00 rows=1,200 width=40) (actual time=0.005..0.006 rows=2 loops=1)

126. 2.000 2.000 ↑ 1.0 1 1,000

Index Scan using epayment_provider_pkey on epayment_provider ep (cost=0.15..0.17 rows=1 width=76) (actual time=0.002..0.002 rows=1 loops=1,000)

  • Index Cond: (id = er.provider_id)
127. 1.000 1.000 ↑ 1.0 1 1,000

Index Scan using equire_agreement_pkey on equire_agreement ea (cost=0.15..0.17 rows=1 width=69) (actual time=0.001..0.001 rows=1 loops=1,000)

  • Index Cond: (id = er.equire_agreement_id)
128. 1.000 1.000 ↑ 1.0 1 1,000

Index Scan using equiring_type_pkey on equiring_type et (cost=0.14..0.29 rows=1 width=6) (actual time=0.001..0.001 rows=1 loops=1,000)

  • Index Cond: (id = ea.type_id)
129. 2.000 2.000 ↓ 0.0 0 1,000

Index Scan using view_refunds_cg_by_client_cg_id_idx on view_refunds_cg_by_client rc (cost=0.29..0.31 rows=1 width=20) (actual time=0.002..0.002 rows=0 loops=1,000)

  • Index Cond: (cg_id = cg.id)
130. 5.000 5.000 ↑ 1.0 1 1,000

Index Scan using sell_report_ticket_cart_id_unique on sell_report sr (cost=0.43..0.52 rows=1 width=12) (actual time=0.005..0.005 rows=1 loops=1,000)

  • Index Cond: (ticket_cart_id = COALESCE(tc.id, dt.ticket_id))
131. 2.000 2.000 ↑ 1.0 1 1,000

Index Scan using admin_user_pkey on admin_user pau (cost=0.29..0.30 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1,000)

  • Index Cond: (id = er.user_id)
132. 2.000 2.000 ↑ 1.0 1 1,000

Index Scan using admin_group_pkey on admin_group pag (cost=0.29..0.36 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1,000)

  • Index Cond: (id = pau."group")
133. 2.000 2.000 ↑ 1.0 1 1,000

Index Scan using "Venue_pkey" on "Venue" v (cost=0.28..0.30 rows=1 width=47) (actual time=0.002..0.002 rows=1 loops=1,000)

  • Index Cond: (id = de.venue_id)
134.          

SubPlan (forNested Loop Left Join)

135. 4.000 4.000 ↑ 1.0 1 1,000

Index Only Scan using order_payments_order_id_idx on order_payments (cost=0.43..8.45 rows=1 width=0) (actual time=0.004..0.004 rows=1 loops=1,000)

  • Index Cond: (order_id = er.order_id)
  • Heap Fetches: 640
136. 0.770 0.770 ↑ 1.0 1 385

Index Only Scan using order_payments_order_id_idx on order_payments order_payments_1 (cost=0.43..8.45 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=385)

  • Index Cond: (order_id = er.order_id)
  • Heap Fetches: 251