explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j0xt

Settings
# exclusive inclusive rows x rows loops node
1. 0.247 4,972.556 ↑ 1.0 1,000 1

Limit (cost=1,074.55..46,230.14 rows=1,000 width=395) (actual time=1,992.520..4,972.556 rows=1,000 loops=1)

2. 1,568.814 4,972.309 ↑ 147.8 1,000 1

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

3. 1.267 2,360.107 ↑ 147.8 1,000 1

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

4. 1.465 2,356.840 ↑ 147.8 1,000 1

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

5. 1.110 2,353.375 ↑ 147.8 1,000 1

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

6. 0.860 2,347.265 ↑ 147.8 1,000 1

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

7. 1.438 2,344.405 ↑ 147.8 1,000 1

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

8. 0.563 2,341.967 ↑ 147.8 1,000 1

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

9. 0.659 2,339.404 ↑ 147.8 1,000 1

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

10. 3.597 2,336.745 ↑ 147.8 1,000 1

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

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

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

12. 0.932 2,330.165 ↑ 147.8 1,000 1

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

13. 0.977 2,329.233 ↑ 147.8 1,000 1

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

14. 0.640 2,328.256 ↑ 147.8 1,000 1

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

15. 1.219 2,321.616 ↑ 147.8 1,000 1

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

16. 1.527 2,316.397 ↑ 147.8 1,000 1

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

17. 0.933 2,313.870 ↑ 147.8 1,000 1

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

18. 1.372 2,309.919 ↑ 146.9 1,006 1

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

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

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

20. 1.163 2,297.444 ↑ 146.9 1,006 1

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

21. 0.957 2,292.257 ↑ 145.1 1,006 1

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

22. 0.974 2,291.300 ↑ 145.1 1,006 1

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

23. 0.860 2,290.326 ↑ 145.1 1,006 1

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

24. 0.618 2,289.466 ↑ 145.1 1,006 1

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

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

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

26. 142.335 2,278.196 ↑ 145.1 1,006 1

Merge Left Join (cost=1,029.73..2,170,032.58 rows=145,935 width=217) (actual time=718.559..2,278.196 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 502.337 ↑ 145.1 1,006 1

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

  • Workers Planned: 2
  • Workers Launched: 2
28. 1.212 2,302.413 ↑ 110.8 549 3

Nested Loop Left Join (cost=2.44..897,784.11 rows=60,806 width=205) (actual time=393.520..767.471 rows=549 loops=3)

  • Join Filter: ((erd.type = 1) AND (tc.order_id = er.order_id))
  • Rows Removed by Join Filter: 1
29. 0.780 2,294.613 ↑ 110.8 549 3

Nested Loop Left Join (cost=2.01..866,282.08 rows=60,806 width=193) (actual time=393.494..764.871 rows=549 loops=3)

  • Join Filter: (er.id = erd_discount.er_id)
30. 0.486 2,283.951 ↑ 110.8 549 3

Nested Loop (cost=1.57..831,751.53 rows=60,806 width=193) (actual time=393.446..761.317 rows=549 loops=3)

31. 1.608 2,252.037 ↑ 12.0 1,746 3

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

32. 0.000 2,239.953 ↑ 12.0 1,746 3

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

33. 612.600 612.600 ↑ 4.9 293,129 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.018..204.200 rows=293,129 loops=3)

34. 1,758.774 1,758.774 ↓ 0.0 0 879,387

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.002..0.002 rows=0 loops=879,387)

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

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

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

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

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

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,647)

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

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

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

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

40. 192.205 1,401.992 ↑ 6.8 1,805,794 1

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

  • Sort Key: dt.order_id
41. 0.016 0.016 ↓ 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.016..0.016 rows=0 loops=1)

42. 39.680 39.680 ↑ 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.024..39.680 rows=84,415 loops=1)

43. 45.317 45.317 ↑ 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.024..45.317 rows=91,848 loops=1)

44. 46.605 46.605 ↑ 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.024..46.605 rows=92,135 loops=1)

45. 38.461 38.461 ↑ 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.018..38.461 rows=78,409 loops=1)

46. 114.463 114.463 ↑ 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.021..114.463 rows=186,385 loops=1)

47. 80.539 80.539 ↑ 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.027..80.539 rows=141,320 loops=1)

48. 53.866 53.866 ↑ 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.016..53.866 rows=94,749 loops=1)

49. 44.372 44.372 ↑ 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.018..44.372 rows=79,077 loops=1)

50. 80.688 80.688 ↑ 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.027..80.688 rows=133,753 loops=1)

51. 124.918 124.918 ↑ 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.045..124.918 rows=161,250 loops=1)

52. 158.112 158.112 ↑ 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.023..158.112 rows=198,022 loops=1)

53. 156.084 156.084 ↑ 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.019..156.084 rows=198,046 loops=1)

54. 116.493 116.493 ↑ 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.022..116.493 rows=148,863 loops=1)

55. 89.014 89.014 ↑ 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.026..89.014 rows=104,410 loops=1)

56. 10.387 10.387 ↑ 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.035..10.387 rows=4,108 loops=1)

57. 2.950 2.950 ↑ 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.022..2.950 rows=1,351 loops=1)

58. 1.134 1.134 ↑ 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.019..1.134 rows=479 loops=1)

59. 0.614 0.614 ↑ 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.614 rows=219 loops=1)

60. 0.822 0.822 ↑ 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.023..0.822 rows=261 loops=1)

61. 0.521 0.521 ↑ 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.024..0.521 rows=195 loops=1)

62. 0.666 0.666 ↑ 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.024..0.666 rows=264 loops=1)

63. 0.381 0.381 ↑ 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.031..0.381 rows=138 loops=1)

64. 0.088 0.088 ↑ 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.031..0.088 rows=12 loops=1)

65. 0.028 0.028 ↑ 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.016..0.028 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.014 0.014 ↑ 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.014..0.014 rows=1 loops=1)

68. 0.032 0.032 ↑ 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.016..0.032 rows=4 loops=1)

69. 0.014 0.014 ↑ 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.014..0.014 rows=1 loops=1)

70. 0.012 0.012 ↑ 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.012..0.012 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.015..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.032 0.032 ↑ 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.032 rows=2 loops=1)

74. 0.020 0.020 ↑ 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.016..0.020 rows=2 loops=1)

75. 0.016 0.016 ↑ 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.016..0.016 rows=1 loops=1)

76. 0.023 0.023 ↑ 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.019..0.023 rows=5 loops=1)

77. 0.021 0.021 ↑ 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.021..0.021 rows=1 loops=1)

78. 0.013 0.013 ↑ 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.013..0.013 rows=1 loops=1)

79. 0.033 0.033 ↑ 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.033..0.033 rows=1 loops=1)

80. 0.018 0.018 ↑ 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.018..0.018 rows=1 loops=1)

81. 0.814 0.814 ↑ 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.016..0.814 rows=1,733 loops=1)

82. 0.020 0.020 ↑ 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.020..0.020 rows=1 loops=1)

83. 0.015 0.015 ↑ 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.015..0.015 rows=1 loops=1)

84. 1.984 1.984 ↑ 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.984 rows=4,308 loops=1)

85. 0.013 0.013 ↑ 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.013..0.013 rows=1 loops=1)

86. 0.052 0.052 ↑ 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.018..0.052 rows=15 loops=1)

87. 0.020 0.020 ↑ 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.020..0.020 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.014 0.014 ↑ 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.014..0.014 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.016 0.016 ↑ 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.016..0.016 rows=1 loops=1)

93. 0.027 0.027 ↑ 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.027..0.027 rows=1 loops=1)

94. 0.021 0.021 ↑ 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.021..0.021 rows=1 loops=1)

95. 0.019 0.019 ↑ 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.019..0.019 rows=1 loops=1)

96. 0.080 0.080 ↑ 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.017..0.080 rows=28 loops=1)

97. 0.014 0.014 ↑ 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.014..0.014 rows=1 loops=1)

98. 0.017 0.017 ↑ 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.017..0.017 rows=1 loops=1)

99. 0.014 0.014 ↑ 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.014..0.014 rows=1 loops=1)

100. 0.013 0.013 ↑ 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.013..0.013 rows=1 loops=1)

101. 0.017 0.017 ↑ 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.017..0.017 rows=1 loops=1)

102. 0.026 0.026 ↑ 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.026..0.026 rows=1 loops=1)

103. 0.010 0.010 ↑ 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.010..0.010 rows=1 loops=1)

104. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

105. 0.005 0.005 ↓ 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.005..0.005 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.934 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.037 0.066 ↑ 1.0 41 1

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

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

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

124. 0.005 0.010 ↑ 600.0 2 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
125. 0.005 0.005 ↑ 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.004..0.005 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. 2.000 2.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.002..0.002 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. 0.000 0.000 ↓ 0.0 0

Index Only Scan using order_payments_order_id_idx on order_payments (cost=0.43..8.45 rows=1 width=0) (never executed)

  • Index Cond: (order_id = er.order_id)
  • Heap Fetches: 0
136. 536.140 536.140 ↓ 1.0 2,658,479 1

Seq Scan on order_payments order_payments_1 (cost=0.00..78,795.49 rows=2,655,041 width=8) (actual time=0.028..536.140 rows=2,658,479 loops=1)

  • Filter: (payment_status_id = 1)
  • Rows Removed by Filter: 643349
137. 0.000 0.000 ↓ 0.0 0

Index Only Scan using order_payments_order_id_idx on order_payments order_payments_2 (cost=0.43..8.45 rows=1 width=0) (never executed)

  • Index Cond: (order_id = er.order_id)
  • Heap Fetches: 0
138. 505.248 505.248 ↓ 1.0 2,658,479 1

Seq Scan on order_payments order_payments_3 (cost=0.00..78,795.49 rows=2,655,041 width=8) (actual time=0.024..505.248 rows=2,658,479 loops=1)

  • Filter: (payment_status_id = 1)
  • Rows Removed by Filter: 643349