explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a2KO

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 3,134.955 ↑ 1.0 1 1

Limit (cost=12,623.40..18,564.55 rows=1 width=395) (actual time=3,134.955..3,134.955 rows=1 loops=1)

  • Planning time: 67.040 ms
  • Execution time: 3141.143 ms
2. 0.023 3,134.954 ↑ 147,622.0 1 1

Nested Loop Left Join (cost=12,623.40..877,056,407.51 rows=147,622 width=395) (actual time=3,134.954..3,134.954 rows=1 loops=1)

3. 0.002 3,134.916 ↑ 147,622.0 1 1

Nested Loop Left Join (cost=12,623.12..874,500,896.41 rows=147,622 width=622) (actual time=3,134.916..3,134.916 rows=1 loops=1)

4. 0.002 3,134.908 ↑ 147,622.0 1 1

Nested Loop Left Join (cost=12,622.83..874,447,390.56 rows=147,622 width=622) (actual time=3,134.908..3,134.908 rows=1 loops=1)

5. 0.003 3,134.899 ↑ 147,622.0 1 1

Nested Loop Left Join (cost=12,622.55..874,402,692.64 rows=147,622 width=622) (actual time=3,134.899..3,134.899 rows=1 loops=1)

6. 0.003 3,134.882 ↑ 147,622.0 1 1

Nested Loop Left Join (cost=12,622.11..874,325,792.60 rows=147,622 width=622) (actual time=3,134.882..3,134.882 rows=1 loops=1)

7. 0.002 3,134.873 ↑ 147,622.0 1 1

Nested Loop (cost=12,621.83..874,280,761.65 rows=147,622 width=606) (actual time=3,134.873..3,134.873 rows=1 loops=1)

  • Join Filter: (ea.type_id = et.id)
  • Rows Removed by Join Filter: 9
8. 0.006 3,134.864 ↑ 147,622.0 1 1

Nested Loop (cost=12,621.83..873,972,925.70 rows=147,622 width=608) (actual time=3,134.864..3,134.864 rows=1 loops=1)

  • Join Filter: (er.equire_agreement_id = ea.id)
  • Rows Removed by Join Filter: 67
9. 0.005 3,134.830 ↑ 147,622.0 1 1

Nested Loop (cost=12,621.83..873,144,743.73 rows=147,622 width=547) (actual time=3,134.830..3,134.830 rows=1 loops=1)

  • Join Filter: (er.provider_id = ep.id)
  • Rows Removed by Join Filter: 41
10. 0.001 3,134.808 ↑ 147,622.0 1 1

Nested Loop Left Join (cost=12,621.83..872,498,136.38 rows=147,622 width=479) (actual time=3,134.808..3,134.808 rows=1 loops=1)

  • Join Filter: (bspt.id = bs.print_type)
  • Rows Removed by Join Filter: 1
11. 0.004 3,134.800 ↑ 147,622.0 1 1

Nested Loop Left Join (cost=12,621.83..869,843,125.70 rows=147,622 width=451) (actual time=3,134.800..3,134.800 rows=1 loops=1)

  • Join Filter: (bs.id = COALESCE(bso.seria_id, bso2.seria_id))
  • Rows Removed by Join Filter: 28
12. 0.003 3,134.776 ↑ 147,622.0 1 1

Nested Loop Left Join (cost=12,621.83..869,752,768.91 rows=147,622 width=455) (actual time=3,134.776..3,134.776 rows=1 loops=1)

13. 0.006 3,134.758 ↑ 147,622.0 1 1

Nested Loop (cost=12,621.39..869,680,760.98 rows=147,622 width=444) (actual time=3,134.758..3,134.758 rows=1 loops=1)

14. 22.007 3,134.693 ↑ 147,622.0 1 1

Nested Loop Left Join (cost=12,620.97..869,521,488.37 rows=147,622 width=444) (actual time=3,134.693..3,134.693 rows=1 loops=1)

  • Join Filter: (ab.id = atp.blank_id)
  • Rows Removed by Join Filter: 389904
15. 0.001 3.596 ↑ 147,622.0 1 1

Nested Loop Left Join (cost=6.37..5,396,604.31 rows=147,622 width=441) (actual time=3.596..3.596 rows=1 loops=1)

16. 0.002 3.590 ↑ 147,622.0 1 1

Nested Loop (cost=5.95..5,324,844.05 rows=147,622 width=433) (actual time=3.590..3.590 rows=1 loops=1)

17. 0.001 3.557 ↑ 147,622.0 1 1

Nested Loop (cost=5.79..5,298,486.90 rows=147,622 width=437) (actual time=3.557..3.557 rows=1 loops=1)

18. 0.001 3.548 ↑ 147,622.0 1 1

Nested Loop Left Join (cost=5.51..5,079,752.73 rows=147,622 width=433) (actual time=3.548..3.548 rows=1 loops=1)

  • Join Filter: (cg.sector_id = gs."foreignID")
19. 0.001 3.528 ↑ 147,622.0 1 1

Nested Loop Left Join (cost=5.09..4,999,133.63 rows=147,622 width=441) (actual time=3.528..3.528 rows=1 loops=1)

20. 0.001 3.502 ↑ 147,622.0 1 1

Nested Loop Left Join (cost=4.67..4,915,813.59 rows=147,622 width=412) (actual time=3.502..3.502 rows=1 loops=1)

21. 0.002 3.490 ↑ 145,784.0 1 1

Nested Loop Left Join (cost=4.25..4,850,390.55 rows=145,784 width=345) (actual time=3.490..3.490 rows=1 loops=1)

22. 0.000 3.485 ↑ 145,784.0 1 1

Nested Loop Left Join (cost=3.82..4,774,161.80 rows=145,784 width=339) (actual time=3.485..3.485 rows=1 loops=1)

23. 0.001 3.477 ↑ 145,784.0 1 1

Nested Loop Left Join (cost=3.41..4,694,842.98 rows=145,784 width=274) (actual time=3.477..3.477 rows=1 loops=1)

24. 0.001 3.475 ↑ 145,784.0 1 1

Nested Loop Left Join (cost=3.13..4,652,121.89 rows=145,784 width=270) (actual time=3.475..3.475 rows=1 loops=1)

  • Join Filter: (erd.type = 4)
25. 0.002 3.446 ↑ 145,784.0 1 1

Nested Loop Left Join (cost=2.71..4,585,527.70 rows=145,784 width=230) (actual time=3.446..3.446 rows=1 loops=1)

26. 0.010 3.427 ↑ 145,784.0 1 1

Nested Loop Left Join (cost=2.27..4,472,543.49 rows=145,784 width=217) (actual time=3.427..3.427 rows=1 loops=1)

  • Join Filter: ((erd.type = 1) AND (dt.order_id = er.order_id))
27. 0.001 2.764 ↑ 145,784.0 1 1

Nested Loop Left Join (cost=2.15..458,216.04 rows=145,784 width=205) (actual time=2.764..2.764 rows=1 loops=1)

  • Join Filter: ((erd.type = 1) AND (tc.order_id = er.order_id))
28. 0.001 2.737 ↑ 145,784.0 1 1

Nested Loop Left Join (cost=1.72..382,689.18 rows=145,784 width=193) (actual time=2.737..2.737 rows=1 loops=1)

  • Join Filter: (er.id = erd_discount.er_id)
29. 0.001 2.716 ↑ 145,784.0 1 1

Nested Loop (cost=1.28..299,058.79 rows=145,784 width=193) (actual time=2.716..2.716 rows=1 loops=1)

30. 0.001 2.704 ↑ 50,183.0 1 1

Nested Loop Left Join (cost=0.72..243,999.20 rows=50,183 width=177) (actual time=2.704..2.704 rows=1 loops=1)

31. 0.002 2.661 ↑ 50,183.0 1 1

Nested Loop (cost=0.43..228,026.02 rows=50,183 width=48) (actual time=2.661..2.661 rows=1 loops=1)

32. 2.642 2.642 ↑ 50,183.0 1 1

Seq Scan on epayment_record_status_log ersl_accepted (cost=0.00..2,993.12 rows=50,183 width=16) (actual time=2.642..2.642 rows=1 loops=1)

  • Filter: (type = 'REFUND_ACCEPTED'::epayment_record_status_log_type)
  • Rows Removed by Filter: 31209
33. 0.017 0.017 ↑ 1.0 1 1

Index Scan using epayment_record_pkey on epayment_record er (cost=0.43..4.48 rows=1 width=32) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: (id = ersl_accepted.er_id)
34. 0.042 0.042 ↑ 1.0 1 1

Index Scan using refunds_requests_er_id_idx on refunds_requests rr (cost=0.29..0.31 rows=1 width=137) (actual time=0.042..0.042 rows=1 loops=1)

  • Index Cond: (er_id = er.id)
35. 0.011 0.011 ↑ 14.0 1 1

Index Scan using uniq_epayment_record_details on epayment_record_details erd (cost=0.56..0.96 rows=14 width=24) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (er_id = er.id)
36. 0.020 0.020 ↓ 0.0 0 1

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

  • Index Cond: (erd.object_id = object_id)
  • Filter: (type = 10)
  • Rows Removed by Filter: 3
37. 0.026 0.026 ↓ 0.0 0 1

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

  • Index Cond: (id = erd.object_id)
38. 0.013 0.653 ↑ 65.0 1 1

Append (cost=0.12..26.56 rows=65 width=16) (actual time=0.653..0.653 rows=1 loops=1)

39. 0.006 0.006 ↓ 0.0 0 1

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

  • Index Cond: (ticket_id = erd.object_id)
40. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201401_ticket_id on deleted_ticket_201401 dt_1 (cost=0.29..0.31 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
41. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201402_ticket_id on deleted_ticket_201402 dt_2 (cost=0.29..0.31 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
42. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201403_ticket_id on deleted_ticket_201403 dt_3 (cost=0.29..0.31 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
43. 0.012 0.012 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201404_ticket_id on deleted_ticket_201404 dt_4 (cost=0.29..0.31 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
44. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201405_ticket_id on deleted_ticket_201405 dt_5 (cost=0.42..0.44 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
45. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201406_ticket_id on deleted_ticket_201406 dt_6 (cost=0.42..0.44 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
46. 0.007 0.007 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201407_ticket_id on deleted_ticket_201407 dt_7 (cost=0.29..0.31 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
47. 0.009 0.009 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201408_ticket_id on deleted_ticket_201408 dt_8 (cost=0.29..0.31 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
48. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201409_ticket_id on deleted_ticket_201409 dt_9 (cost=0.42..0.44 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
49. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201410_ticket_id on deleted_ticket_201410 dt_10 (cost=0.42..0.44 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
50. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201411_ticket_id on deleted_ticket_201411 dt_11 (cost=0.42..0.44 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
51. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201412_ticket_id on deleted_ticket_201412 dt_12 (cost=0.42..0.44 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
52. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201501_ticket_id on deleted_ticket_201501 dt_13 (cost=0.42..0.44 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
53. 0.012 0.012 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201502_ticket_id on deleted_ticket_201502 dt_14 (cost=0.42..0.44 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
54. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201503_ticket_id on deleted_ticket_201503 dt_15 (cost=0.42..0.44 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
55. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201504_ticket_id on deleted_ticket_201504 dt_16 (cost=0.42..0.44 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
56. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201505_ticket_id on deleted_ticket_201505 dt_17 (cost=0.42..0.44 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
57. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201506_ticket_id on deleted_ticket_201506 dt_18 (cost=0.42..0.44 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
58. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201507_ticket_id on deleted_ticket_201507 dt_19 (cost=0.42..0.44 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
59. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201508_ticket_id on deleted_ticket_201508 dt_20 (cost=0.42..0.44 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
60. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201509_ticket_id on deleted_ticket_201509 dt_21 (cost=0.42..0.44 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
61. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201510_ticket_id on deleted_ticket_201510 dt_22 (cost=0.42..0.44 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
62. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201511_ticket_id on deleted_ticket_201511 dt_23 (cost=0.42..0.44 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
63. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201512_ticket_id on deleted_ticket_201512 dt_24 (cost=0.42..0.44 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
64. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201601_ticket_id on deleted_ticket_201601 dt_25 (cost=0.42..0.44 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
65. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201602_ticket_id on deleted_ticket_201602 dt_26 (cost=0.42..0.44 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
66. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201603_ticket_id on deleted_ticket_201603 dt_27 (cost=0.42..0.44 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
67. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201604_ticket_id on deleted_ticket_201604 dt_28 (cost=0.42..0.44 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
68. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201605_ticket_id on deleted_ticket_201605 dt_29 (cost=0.42..0.44 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
69. 0.016 0.016 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201606_ticket_id on deleted_ticket_201606 dt_30 (cost=0.42..0.44 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
70. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201607_ticket_id on deleted_ticket_201607 dt_31 (cost=0.42..0.44 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
71. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201608_ticket_id on deleted_ticket_201608 dt_32 (cost=0.42..0.44 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
72. 0.016 0.016 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201609_ticket_id on deleted_ticket_201609 dt_33 (cost=0.42..0.44 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
73. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201610_ticket_id on deleted_ticket_201610 dt_34 (cost=0.42..0.44 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
74. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201611_ticket_id on deleted_ticket_201611 dt_35 (cost=0.42..0.44 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
75. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201612_ticket_id on deleted_ticket_201612 dt_36 (cost=0.42..0.44 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
76. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201701_ticket_id on deleted_ticket_201701 dt_37 (cost=0.42..0.44 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
77. 0.007 0.007 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201702_ticket_id on deleted_ticket_201702 dt_38 (cost=0.42..0.44 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
78. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201703_ticket_id on deleted_ticket_201703 dt_39 (cost=0.42..0.44 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
79. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201704_ticket_id on deleted_ticket_201704 dt_40 (cost=0.42..0.44 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
80. 0.012 0.012 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201705_ticket_id on deleted_ticket_201705 dt_41 (cost=0.42..0.44 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
81. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201706_ticket_id on deleted_ticket_201706 dt_42 (cost=0.42..0.44 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
82. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201707_ticket_id on deleted_ticket_201707 dt_43 (cost=0.42..0.44 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
83. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201708_ticket_id on deleted_ticket_201708 dt_44 (cost=0.42..0.44 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
84. 0.012 0.012 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201709_ticket_id on deleted_ticket_201709 dt_45 (cost=0.42..0.44 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
85. 0.021 0.021 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201710_ticket_id on deleted_ticket_201710 dt_46 (cost=0.42..0.44 rows=1 width=16) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
86. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201711_ticket_id on deleted_ticket_201711 dt_47 (cost=0.42..0.44 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
87. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201712_ticket_id on deleted_ticket_201712 dt_48 (cost=0.42..0.44 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
88. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201801_ticket_id on deleted_ticket_201801 dt_49 (cost=0.42..0.44 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
89. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201802_ticket_id on deleted_ticket_201802 dt_50 (cost=0.42..0.44 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
90. 0.012 0.012 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201803_ticket_id on deleted_ticket_201803 dt_51 (cost=0.42..0.44 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
91. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201804_ticket_id on deleted_ticket_201804 dt_52 (cost=0.42..0.44 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
92. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_deleted_ticket_201805_ticket_id on deleted_ticket_201805 dt_53 (cost=0.42..0.44 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
93. 0.023 0.023 ↑ 1.0 1 1

Index Scan using ix_deleted_ticket_201806_ticket_id on deleted_ticket_201806 dt_54 (cost=0.42..0.44 rows=1 width=16) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
94. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_deleted_ticket_201807_ticket_id on deleted_ticket_201807 dt_55 (cost=0.42..0.44 rows=1 width=16) (never executed)

  • Index Cond: (ticket_id = erd.object_id)
95. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_deleted_ticket_201808_ticket_id on deleted_ticket_201808 dt_56 (cost=0.42..0.44 rows=1 width=16) (never executed)

  • Index Cond: (ticket_id = erd.object_id)
96. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_deleted_ticket_201809_ticket_id on deleted_ticket_201809 dt_57 (cost=0.42..0.44 rows=1 width=16) (never executed)

  • Index Cond: (ticket_id = erd.object_id)
97. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_deleted_ticket_201810_ticket_id on deleted_ticket_201810 dt_58 (cost=0.42..0.44 rows=1 width=16) (never executed)

  • Index Cond: (ticket_id = erd.object_id)
98. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_deleted_ticket_201811_ticket_id on deleted_ticket_201811 dt_59 (cost=0.42..0.44 rows=1 width=16) (never executed)

  • Index Cond: (ticket_id = erd.object_id)
99. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_deleted_ticket_201812_ticket_id on deleted_ticket_201812 dt_60 (cost=0.42..0.44 rows=1 width=16) (never executed)

  • Index Cond: (ticket_id = erd.object_id)
100. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_deleted_ticket_201901_ticket_id on deleted_ticket_201901 dt_61 (cost=0.29..0.31 rows=1 width=16) (never executed)

  • Index Cond: (ticket_id = erd.object_id)
101. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_deleted_ticket_201902_ticket_id on deleted_ticket_201902 dt_62 (cost=0.15..0.17 rows=1 width=16) (never executed)

  • Index Cond: (ticket_id = erd.object_id)
102. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_deleted_ticket_201903_ticket_id on deleted_ticket_201903 dt_63 (cost=0.14..0.16 rows=1 width=16) (never executed)

  • Index Cond: (ticket_id = erd.object_id)
103. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_deleted_ticket_201904_ticket_id on deleted_ticket_201904 dt_64 (cost=0.14..0.16 rows=1 width=16) (never executed)

  • Index Cond: (ticket_id = erd.object_id)
104. 0.017 0.017 ↑ 1.0 1 1

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

  • Index Cond: (id = COALESCE(tc.gw_ticket_id, dt.gw_ticket_id))
105. 0.028 0.028 ↓ 0.0 0 1

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

  • Index Cond: (id = erd.object_id)
106. 0.001 0.001 ↓ 0.0 0 1

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

  • Index Cond: (at.gateway_id = id)
107. 0.008 0.008 ↓ 0.0 0 1

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

  • Index Cond: ((gateway_id = at.gateway_id) AND (foreign_id = at.subevent_id))
108. 0.003 0.003 ↓ 0.0 0 1

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

  • Index Cond: ((gateway_id = at.gateway_id) AND (foreign_id = at.sector_id) AND (venue_configuration_id = at.venue_configuration_id))
109. 0.011 0.011 ↑ 1.0 1 1

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.011..0.011 rows=1 loops=1)

  • Index Cond: (cg.event_id = event_id)
110. 0.025 0.025 ↑ 1.0 1 1

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.025..0.025 rows=1 loops=1)

  • Index Cond: ((cache_gateway_event_id = cge.id) AND (sector_id = cg.sector_id))
111. 0.019 0.019 ↑ 1.0 1 1

Index Scan using "GatewaySector_foreignEventID_GateWayClassId_idx" on "GatewaySector" gs (cost=0.42..0.53 rows=1 width=16) (actual time=0.019..0.019 rows=1 loops=1)

  • Index Cond: ((cge.event_id = "foreignEventID") AND (cge.gateway_id = "GateWayClassId"))
112. 0.008 0.008 ↑ 1.0 1 1

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

  • Index Cond: (id = COALESCE(cge.hamster_id, gwn.default_hamster))
113. 0.031 0.031 ↑ 1.0 1 1

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

  • Index Cond: (id = h.closure_id)
  • Heap Fetches: 1
114. 0.005 0.005 ↓ 0.0 0 1

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

  • Index Cond: (at.id = ticket_id)
115. 66.815 3,109.090 ↑ 1.0 389,904 1

Materialize (cost=12,614.60..749,734.50 rows=389,904 width=19) (actual time=126.821..3,109.090 rows=389,904 loops=1)

116. 1,984.768 3,042.275 ↑ 1.0 389,904 1

Hash Right Join (cost=12,614.60..747,784.98 rows=389,904 width=19) (actual time=126.818..3,042.275 rows=389,904 loops=1)

  • Hash Cond: (((bso2.bso_seria_id)::text = (ab.seria)::text) AND (bso2.bso_id = ab.number))
117. 932.013 932.013 ↑ 1.0 7,373,470 1

Seq Scan on bso_blank bso2 (cost=0.00..215,652.52 rows=7,373,552 width=11) (actual time=0.016..932.013 rows=7,373,470 loops=1)

118. 74.210 125.494 ↑ 1.0 389,904 1

Hash (cost=6,766.04..6,766.04 rows=389,904 width=15) (actual time=125.494..125.494 rows=389,904 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 22373kB
119. 51.284 51.284 ↑ 1.0 389,904 1

Seq Scan on blanks ab (cost=0.00..6,766.04 rows=389,904 width=15) (actual time=0.009..51.284 rows=389,904 loops=1)

120. 0.059 0.059 ↑ 1.0 1 1

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

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

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

  • Index Cond: (gw_ticket_id = cg.id)
122. 0.005 0.020 ↑ 1.4 29 1

Materialize (cost=0.00..1.62 rows=41 width=8) (actual time=0.014..0.020 rows=29 loops=1)

123. 0.015 0.015 ↑ 1.4 29 1

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

124. 0.003 0.007 ↑ 600.0 2 1

Materialize (cost=0.00..28.00 rows=1,200 width=40) (actual time=0.006..0.007 rows=2 loops=1)

125. 0.004 0.004 ↑ 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.003..0.004 rows=2 loops=1)

126. 0.007 0.017 ↑ 7.0 42 1

Materialize (cost=0.00..9.39 rows=293 width=76) (actual time=0.007..0.017 rows=42 loops=1)

127. 0.010 0.010 ↑ 7.0 42 1

Seq Scan on epayment_provider ep (cost=0.00..7.93 rows=293 width=76) (actual time=0.006..0.010 rows=42 loops=1)

128. 0.013 0.028 ↑ 5.5 68 1

Materialize (cost=0.00..13.62 rows=375 width=69) (actual time=0.009..0.028 rows=68 loops=1)

129. 0.015 0.015 ↑ 5.5 68 1

Seq Scan on equire_agreement ea (cost=0.00..11.75 rows=375 width=69) (actual time=0.006..0.015 rows=68 loops=1)

130. 0.002 0.007 ↑ 14.0 10 1

Materialize (cost=0.00..12.10 rows=140 width=6) (actual time=0.005..0.007 rows=10 loops=1)

131. 0.005 0.005 ↑ 14.0 10 1

Seq Scan on equiring_type et (cost=0.00..11.40 rows=140 width=6) (actual time=0.004..0.005 rows=10 loops=1)

132. 0.006 0.006 ↑ 1.0 1 1

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.006..0.006 rows=1 loops=1)

  • Index Cond: (cg_id = cg.id)
133. 0.014 0.014 ↑ 1.0 1 1

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

  • Index Cond: (ticket_cart_id = COALESCE(tc.id, dt.ticket_id))
134. 0.007 0.007 ↑ 1.0 1 1

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

  • Index Cond: (id = er.user_id)
135. 0.006 0.006 ↑ 1.0 1 1

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

  • Index Cond: (id = pau."group")
136. 0.007 0.007 ↑ 1.0 1 1

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

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

SubPlan (forNested Loop Left Join)

138. 0.008 0.008 ↓ 0.0 0 1

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

  • Index Cond: (order_id = er.order_id)
  • Heap Fetches: 0
139. 0.000 0.000 ↓ 0.0 0

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

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