explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JMVE

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

Limit (cost=12,623.27..18,564.36 rows=1 width=395) (actual time=3,220.208..3,220.208 rows=1 loops=1)

2. 0.031 3,220.207 ↑ 147,769.0 1 1

Nested Loop Left Join (cost=12,623.27..877,920,613.26 rows=147,769 width=395) (actual time=3,220.207..3,220.207 rows=1 loops=1)

3. 0.002 3,220.158 ↑ 147,769.0 1 1

Nested Loop Left Join (cost=12,622.99..875,362,557.41 rows=147,769 width=622) (actual time=3,220.158..3,220.158 rows=1 loops=1)

4. 0.001 3,220.149 ↑ 147,769.0 1 1

Nested Loop Left Join (cost=12,622.71..875,308,998.28 rows=147,769 width=622) (actual time=3,220.149..3,220.149 rows=1 loops=1)

5. 0.003 3,220.141 ↑ 147,769.0 1 1

Nested Loop Left Join (cost=12,622.42..875,264,255.83 rows=147,769 width=622) (actual time=3,220.141..3,220.141 rows=1 loops=1)

6. 0.002 3,220.117 ↑ 147,769.0 1 1

Nested Loop Left Join (cost=12,621.99..875,187,279.21 rows=147,769 width=622) (actual time=3,220.117..3,220.117 rows=1 loops=1)

7. 0.002 3,220.108 ↑ 147,769.0 1 1

Nested Loop (cost=12,621.70..875,142,203.42 rows=147,769 width=606) (actual time=3,220.108..3,220.108 rows=1 loops=1)

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

Nested Loop (cost=12,621.70..874,834,060.84 rows=147,769 width=608) (actual time=3,220.096..3,220.096 rows=1 loops=1)

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

Nested Loop (cost=12,621.70..874,005,051.99 rows=147,769 width=547) (actual time=3,220.062..3,220.062 rows=1 loops=1)

  • Join Filter: (er.provider_id = ep.id)
  • Rows Removed by Join Filter: 41
10. 0.002 3,220.041 ↑ 147,769.0 1 1

Nested Loop Left Join (cost=12,621.70..873,357,798.59 rows=147,769 width=479) (actual time=3,220.041..3,220.041 rows=1 loops=1)

  • Join Filter: (bspt.id = bs.print_type)
  • Rows Removed by Join Filter: 1
11. 0.003 3,220.032 ↑ 147,769.0 1 1

Nested Loop Left Join (cost=12,621.70..870,700,141.90 rows=147,769 width=451) (actual time=3,220.032..3,220.032 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,220.008 ↑ 147,769.0 1 1

Nested Loop Left Join (cost=12,621.70..870,609,695.29 rows=147,769 width=455) (actual time=3,220.008..3,220.008 rows=1 loops=1)

13. 0.007 3,219.983 ↑ 147,769.0 1 1

Nested Loop (cost=12,621.27..870,537,615.66 rows=147,769 width=444) (actual time=3,219.983..3,219.983 rows=1 loops=1)

14. 22.530 3,219.908 ↑ 147,769.0 1 1

Nested Loop Left Join (cost=12,620.84..870,378,184.44 rows=147,769 width=444) (actual time=3,219.908..3,219.908 rows=1 loops=1)

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

Nested Loop Left Join (cost=6.25..5,393,562.06 rows=147,769 width=441) (actual time=3.595..3.595 rows=1 loops=1)

16. 0.001 3.586 ↑ 147,769.0 1 1

Nested Loop (cost=5.82..5,321,730.35 rows=147,769 width=433) (actual time=3.586..3.586 rows=1 loops=1)

17. 0.001 3.549 ↑ 147,769.0 1 1

Nested Loop (cost=5.67..5,295,346.95 rows=147,769 width=437) (actual time=3.549..3.549 rows=1 loops=1)

18. 0.002 3.539 ↑ 147,769.0 1 1

Nested Loop Left Join (cost=5.39..5,076,394.93 rows=147,769 width=433) (actual time=3.539..3.539 rows=1 loops=1)

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

Nested Loop Left Join (cost=4.96..4,995,695.56 rows=147,769 width=441) (actual time=3.515..3.515 rows=1 loops=1)

20. 0.002 3.483 ↑ 147,769.0 1 1

Nested Loop Left Join (cost=4.54..4,912,292.54 rows=147,769 width=412) (actual time=3.483..3.483 rows=1 loops=1)

21. 0.001 3.464 ↑ 145,929.0 1 1

Nested Loop Left Join (cost=4.12..4,846,804.44 rows=145,929 width=345) (actual time=3.464..3.464 rows=1 loops=1)

22. 0.001 3.460 ↑ 145,929.0 1 1

Nested Loop Left Join (cost=3.70..4,770,499.86 rows=145,929 width=339) (actual time=3.460..3.460 rows=1 loops=1)

23. 0.000 3.454 ↑ 145,929.0 1 1

Nested Loop Left Join (cost=3.28..4,691,102.15 rows=145,929 width=274) (actual time=3.454..3.454 rows=1 loops=1)

24. 0.002 3.453 ↑ 145,929.0 1 1

Nested Loop Left Join (cost=3.01..4,648,338.58 rows=145,929 width=270) (actual time=3.453..3.453 rows=1 loops=1)

  • Join Filter: (erd.type = 4)
25. 0.001 3.416 ↑ 145,929.0 1 1

Nested Loop Left Join (cost=2.58..4,581,678.14 rows=145,929 width=230) (actual time=3.416..3.416 rows=1 loops=1)

26. 0.011 3.389 ↑ 145,929.0 1 1

Nested Loop Left Join (cost=2.15..4,468,581.55 rows=145,929 width=217) (actual time=3.389..3.389 rows=1 loops=1)

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

Nested Loop Left Join (cost=2.02..450,261.15 rows=145,929 width=205) (actual time=2.620..2.620 rows=1 loops=1)

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

Nested Loop Left Join (cost=1.59..374,659.08 rows=145,929 width=193) (actual time=2.587..2.587 rows=1 loops=1)

  • Join Filter: (er.id = erd_discount.er_id)
29. 0.000 2.570 ↑ 145,929.0 1 1

Nested Loop (cost=1.16..291,788.81 rows=145,929 width=193) (actual time=2.570..2.570 rows=1 loops=1)

30. 0.001 2.540 ↑ 50,210.0 1 1

Nested Loop Left Join (cost=0.72..244,076.92 rows=50,210 width=177) (actual time=2.540..2.540 rows=1 loops=1)

31. 0.003 2.496 ↑ 50,210.0 1 1

Nested Loop (cost=0.43..228,095.13 rows=50,210 width=48) (actual time=2.496..2.496 rows=1 loops=1)

32. 2.475 2.475 ↑ 50,210.0 1 1

Seq Scan on epayment_record_status_log ersl_accepted (cost=0.00..2,994.15 rows=50,210 width=16) (actual time=2.475..2.475 rows=1 loops=1)

  • Filter: (type = 'REFUND_ACCEPTED'::epayment_record_status_log_type)
  • Rows Removed by Filter: 31209
33. 0.018 0.018 ↑ 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.018..0.018 rows=1 loops=1)

  • Index Cond: (id = ersl_accepted.er_id)
34. 0.043 0.043 ↑ 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.043..0.043 rows=1 loops=1)

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

Index Scan using uniq_epayment_record_details on epayment_record_details erd (cost=0.43..0.81 rows=14 width=24) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: (er_id = er.id)
36. 0.016 0.016 ↓ 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.016..0.016 rows=0 loops=1)

  • Index Cond: (erd.object_id = object_id)
  • Filter: (type = 10)
  • Rows Removed by Filter: 3
37. 0.032 0.032 ↓ 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.032..0.032 rows=0 loops=1)

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

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

39. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
40. 0.014 0.014 ↓ 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.014..0.014 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
41. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
42. 0.014 0.014 ↓ 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.014..0.014 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
43. 0.013 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
44. 0.016 0.016 ↓ 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.016..0.016 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
45. 0.017 0.017 ↓ 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.017..0.017 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
46. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
47. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
48. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
49. 0.013 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
50. 0.016 0.016 ↓ 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.016..0.016 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
51. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
52. 0.017 0.017 ↓ 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.017..0.017 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
53. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
54. 0.016 0.016 ↓ 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.016..0.016 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
55. 0.012 0.012 ↓ 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.012..0.012 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.015 0.015 ↓ 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.015..0.015 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
58. 0.014 0.014 ↓ 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.014..0.014 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
59. 0.013 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
60. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
61. 0.012 0.012 ↓ 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.012..0.012 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.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
65. 0.022 0.022 ↓ 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.022..0.022 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
66. 0.014 0.014 ↓ 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.014..0.014 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
67. 0.013 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
68. 0.016 0.016 ↓ 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.016..0.016 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
69. 0.018 0.018 ↓ 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.018..0.018 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
70. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
71. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
72. 0.013 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
73. 0.015 0.015 ↓ 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.015..0.015 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
74. 0.020 0.020 ↓ 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.020..0.020 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
75. 0.013 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
76. 0.015 0.015 ↓ 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.015..0.015 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
77. 0.008 0.008 ↓ 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.008..0.008 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.015 0.015 ↓ 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.015..0.015 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
80. 0.020 0.020 ↓ 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.020..0.020 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.017 0.017 ↓ 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.017..0.017 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
83. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
84. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
85. 0.018 0.018 ↓ 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.018..0.018 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
86. 0.009 0.009 ↓ 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.009..0.009 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.014 0.014 ↓ 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.014..0.014 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
90. 0.016 0.016 ↓ 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.016..0.016 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
91. 0.017 0.017 ↓ 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.017..0.017 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
92. 0.013 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Index Cond: (ticket_id = erd.object_id)
93. 0.031 0.031 ↑ 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.031..0.031 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.026 0.026 ↑ 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.026..0.026 rows=1 loops=1)

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

Index Scan using tickets_pkey on tickets at (cost=0.42..0.44 rows=1 width=48) (actual time=0.035..0.035 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.005 0.005 ↓ 0.0 0 1

Index Scan using subevents_pkey on subevents asub (cost=0.42..0.54 rows=1 width=89) (actual time=0.005..0.005 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.017 0.017 ↑ 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.017..0.017 rows=1 loops=1)

  • Index Cond: (cg.event_id = event_id)
110. 0.031 0.031 ↑ 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.031..0.031 rows=1 loops=1)

  • Index Cond: ((cache_gateway_event_id = cge.id) AND (sector_id = cg.sector_id))
111. 0.022 0.022 ↑ 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.022..0.022 rows=1 loops=1)

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

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

  • Index Cond: (id = COALESCE(cge.hamster_id, gwn.default_hamster))
113. 0.036 0.036 ↑ 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.036..0.036 rows=1 loops=1)

  • Index Cond: (id = h.closure_id)
  • Heap Fetches: 1
114. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

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

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

116. 1,985.941 3,121.039 ↑ 1.0 389,904 1

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

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

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

118. 80.373 141.227 ↑ 1.0 389,904 1

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

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

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

120. 0.068 0.068 ↑ 1.0 1 1

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

  • Index Cond: (id = COALESCE((gs."eventID")::bigint, asub.dateevent_id))
121. 0.022 0.022 ↑ 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.022..0.022 rows=1 loops=1)

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

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

123. 0.016 0.016 ↑ 1.4 29 1

Seq Scan on bso_seria bs (cost=0.00..1.41 rows=41 width=8) (actual time=0.013..0.016 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.016 ↑ 7.0 42 1

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

127. 0.009 0.009 ↑ 7.0 42 1

Seq Scan on epayment_provider ep (cost=0.00..7.93 rows=293 width=76) (actual time=0.006..0.009 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.010 ↑ 14.0 10 1

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

131. 0.008 0.008 ↑ 14.0 10 1

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

132. 0.007 0.007 ↑ 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.007..0.007 rows=1 loops=1)

  • Index Cond: (cg_id = cg.id)
133. 0.021 0.021 ↑ 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.021..0.021 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.007 0.007 ↑ 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.007..0.007 rows=1 loops=1)

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

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

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

SubPlan (forNested Loop Left Join)

138. 0.010 0.010 ↓ 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.010..0.010 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