explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vsxb

Settings
# exclusive inclusive rows x rows loops node
1. 2.287 15.834 ↓ 2.2 1,392 1

Sort (cost=701.96..703.54 rows=632 width=860) (actual time=15.635..15.834 rows=1,392 loops=1)

  • Sort Key: "*SELECT* 1"."transmissionType", "*SELECT* 1"."transmissionId
  • Sort Method: quicksort Memory: 592kB
2. 0.414 13.547 ↓ 2.2 1,392 1

Hash Left Join (cost=2.91..672.56 rows=632 width=860) (actual time=0.075..13.547 rows=1,392 loops=1)

  • Hash Cond: ("*SELECT* 1"."shopRef" = shop.id)
3. 0.354 13.117 ↓ 2.2 1,392 1

Hash Left Join (cost=1.64..668.54 rows=632 width=742) (actual time=0.055..13.117 rows=1,392 loops=1)

  • Hash Cond: ("*SELECT* 1"."supplierRef" = sup.id)
4. 0.121 12.743 ↓ 2.2 1,392 1

Append (cost=0.42..664.62 rows=632 width=624) (actual time=0.028..12.743 rows=1,392 loops=1)

5. 0.000 0.052 ↓ 6.0 6 1

Subquery Scan on *SELECT* 1 (cost=0.42..16.56 rows=1 width=663) (actual time=0.027..0.052 rows=6 loops=1)

6. 0.010 0.052 ↓ 6.0 6 1

Nested Loop (cost=0.42..16.55 rows=1 width=631) (actual time=0.027..0.052 rows=6 loops=1)

7. 0.018 0.018 ↓ 6.0 6 1

Index Scan using "index_OrderTransmissionDO_cDate" on "OrderTransmissionDO" ot (cost=0.14..8.20 rows=1 width=592) (actual time=0.014..0.018 rows=6 loops=1)

  • Index Cond: (("creationDate" >= '2018-05-14 16:14:53.976467'::timestamp without time zone) AND ("creationDate" <= '2019-05-16 16:14:53.975467'::timestamp without time zone))
  • Filter: (("supplierRef" IS NULL) OR ("supplierRef" = ANY ('{0,1,3000,2000,1200,1000,1210,1100,10000,10005,10010,10015,10020,1211,1212,10002,10001,10003,10007,10006,10008,10012,10011,10013,10017,10016,10018,10022,10021, (...)
8. 0.024 0.024 ↑ 1.0 1 6

Index Scan using "OrderDO_pkey" on "OrderDO" odo (cost=0.28..8.33 rows=1 width=55) (actual time=0.004..0.004 rows=1 loops=6)

  • Index Cond: (id = ot."orderRef")
  • Filter: ("shopRef" = ANY ('{0,1,200,100,300,210,230,500,220,110,120,111,10300,10296,10384,10380,10442,10446,10518,10510,10590,10582,10301,10297,10385,10381,10445,10447,10519,10513,10591,10587}'::bigint[]))
9. 0.001 2.089 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=60.19..105.58 rows=1 width=663) (actual time=2.089..2.089 rows=0 loops=1)

10. 1.079 2.088 ↓ 0.0 0 1

Hash Join (cost=60.19..105.57 rows=1 width=623) (actual time=2.088..2.088 rows=0 loops=1)

  • Hash Cond: (it."orderRef" = odo_1.id)
11. 0.227 0.227 ↓ 1.0 684 1

Seq Scan on "InvoicingTransmissionDO" it (cost=0.00..42.90 rows=660 width=584) (actual time=0.006..0.227 rows=684 loops=1)

  • Filter: (("creationDate" >= '2018-05-14 16:14:53.976467'::timestamp without time zone) AND ("creationDate" <= '2019-05-16 16:14:53.975467'::timestamp without time zone))
12. 0.285 0.782 ↓ 1.3 606 1

Hash (cost=54.30..54.30 rows=471 width=55) (actual time=0.782..0.782 rows=606 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 62kB
13. 0.497 0.497 ↓ 1.3 606 1

Seq Scan on "OrderDO" odo_1 (cost=0.00..54.30 rows=471 width=55) (actual time=0.004..0.497 rows=606 loops=1)

  • Filter: ("shopRef" = ANY ('{0,1,200,100,300,210,230,500,220,110,120,111,10300,10296,10384,10380,10442,10446,10518,10510,10590,10582,10301,10297,10385,10381,10445,10447,10519,10513,10591,10587}'::bigint[]))
14. 0.093 4.148 ↓ 1.3 684 1

Subquery Scan on *SELECT* 3 (cost=113.45..165.00 rows=519 width=663) (actual time=3.017..4.148 rows=684 loops=1)

15. 0.729 4.055 ↓ 1.3 684 1

Hash Left Join (cost=113.45..159.81 rows=519 width=623) (actual time=3.016..4.055 rows=684 loops=1)

  • Hash Cond: (i2o."orderRef" = odo_2.id)
16. 0.321 1.108 ↓ 1.3 684 1

Hash Join (cost=75.81..115.04 rows=519 width=592) (actual time=0.697..1.108 rows=684 loops=1)

  • Hash Cond: (i2o."invoicingRef" = it_1."invoicingRef")
17. 0.118 0.118 ↓ 1.1 696 1

Seq Scan on "Invoicing2OrderDO" i2o (cost=0.00..31.57 rows=657 width=16) (actual time=0.009..0.118 rows=696 loops=1)

18. 0.175 0.669 ↓ 1.3 684 1

Hash (cost=69.30..69.30 rows=521 width=592) (actual time=0.669..0.669 rows=684 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 78kB
19. 0.494 0.494 ↓ 1.3 684 1

Seq Scan on "InvoicingTransmissionDO" it_1 (cost=0.00..69.30 rows=521 width=592) (actual time=0.012..0.494 rows=684 loops=1)

  • Filter: (("creationDate" >= '2018-05-14 16:14:53.976467'::timestamp without time zone) AND ("creationDate" <= '2019-05-16 16:14:53.975467'::timestamp without time zone) AND ("shopRef" = ANY ('{0,1,200,100,3 (...)
20. 0.128 2.218 ↑ 1.0 606 1

Hash (cost=30.06..30.06 rows=606 width=47) (actual time=2.218..2.218 rows=606 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 57kB
21. 2.090 2.090 ↑ 1.0 606 1

Seq Scan on "OrderDO" odo_2 (cost=0.00..30.06 rows=606 width=47) (actual time=0.007..2.090 rows=606 loops=1)

22. 0.080 3.602 ↓ 7.2 690 1

Subquery Scan on *SELECT* 4 (cost=168.53..226.51 rows=96 width=406) (actual time=2.597..3.602 rows=690 loops=1)

23. 0.486 3.522 ↓ 7.2 690 1

Hash Join (cost=168.53..225.55 rows=96 width=406) (actual time=2.597..3.522 rows=690 loops=1)

  • Hash Cond: (odo_3.id = scm."orderRef")
24. 0.466 0.466 ↓ 1.3 606 1

Seq Scan on "OrderDO" odo_3 (cost=0.00..54.30 rows=471 width=55) (actual time=0.010..0.466 rows=606 loops=1)

  • Filter: ("shopRef" = ANY ('{0,1,200,100,300,210,230,500,220,110,120,111,10300,10296,10384,10380,10442,10446,10518,10510,10590,10582,10301,10297,10385,10381,10445,10447,10519,10513,10591,10587}'::bigint[]))
25. 0.313 2.570 ↓ 5.6 690 1

Hash (cost=166.98..166.98 rows=124 width=367) (actual time=2.570..2.570 rows=690 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 253kB
26. 0.234 2.257 ↓ 5.6 690 1

Hash Left Join (cost=100.92..166.98 rows=124 width=367) (actual time=1.024..2.257 rows=690 loops=1)

  • Hash Cond: (scm."returnAnnouncementRef" = scm_retando.id)
  • Filter: ((COALESCE(scm_d."supplierRef", scm_rdo."supplierRef", scm_ddo."supplierRef", scm_retdo."supplierRef", scm_retando."supplierRef") IS NULL) OR (COALESCE(scm_d."supplierRef", scm_rdo."supplierRef", scm_ddo. (...)
27. 0.118 1.988 ↑ 1.0 690 1

Hash Left Join (cost=96.34..159.76 rows=690 width=367) (actual time=0.984..1.988 rows=690 loops=1)

  • Hash Cond: (scm."returnRef" = scm_retdo.id)
28. 0.252 1.818 ↑ 1.0 690 1

Hash Left Join (cost=91.18..152.00 rows=690 width=367) (actual time=0.927..1.818 rows=690 loops=1)

  • Hash Cond: (scm."dispatchRef" = scm_ddo.id)
29. 0.143 1.417 ↑ 1.0 690 1

Hash Left Join (cost=75.43..130.97 rows=690 width=367) (actual time=0.771..1.417 rows=690 loops=1)

  • Hash Cond: (scm."responseRef" = scm_rdo.id)
30. 0.245 0.875 ↑ 1.0 690 1

Hash Left Join (cost=39.31..92.26 rows=690 width=367) (actual time=0.365..0.875 rows=690 loops=1)

  • Hash Cond: (scm."documentRef" = scm_d.id)
31. 0.276 0.276 ↑ 1.0 690 1

Seq Scan on "ShopCustomerMailTransmissionDO" scm (cost=0.00..50.35 rows=690 width=367) (actual time=0.006..0.276 rows=690 loops=1)

  • Filter: (("creationDate" >= '2018-05-14 16:14:53.976467'::timestamp without time zone) AND ("creationDate" <= '2019-05-16 16:14:53.975467'::timestamp without time zone))
32. 0.099 0.354 ↓ 1.0 642 1

Hash (cost=31.36..31.36 rows=636 width=16) (actual time=0.354..0.354 rows=642 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
33. 0.255 0.255 ↓ 1.0 642 1

Seq Scan on "DocumentDO" scm_d (cost=0.00..31.36 rows=636 width=16) (actual time=0.005..0.255 rows=642 loops=1)

34. 0.108 0.399 ↓ 1.0 678 1

Hash (cost=27.72..27.72 rows=672 width=16) (actual time=0.399..0.399 rows=678 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
35. 0.291 0.291 ↓ 1.0 678 1

Seq Scan on "ResponseDO" scm_rdo (cost=0.00..27.72 rows=672 width=16) (actual time=0.007..0.291 rows=678 loops=1)

36. 0.042 0.149 ↑ 1.0 300 1

Hash (cost=12.00..12.00 rows=300 width=16) (actual time=0.149..0.149 rows=300 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
37. 0.107 0.107 ↑ 1.0 300 1

Seq Scan on "DispatchDO" scm_ddo (cost=0.00..12.00 rows=300 width=16) (actual time=0.004..0.107 rows=300 loops=1)

38. 0.017 0.052 ↑ 1.0 96 1

Hash (cost=3.96..3.96 rows=96 width=16) (actual time=0.052..0.052 rows=96 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
39. 0.035 0.035 ↑ 1.0 96 1

Seq Scan on "ReturnDO" scm_retdo (cost=0.00..3.96 rows=96 width=16) (actual time=0.003..0.035 rows=96 loops=1)

40. 0.010 0.035 ↓ 1.0 72 1

Hash (cost=3.70..3.70 rows=70 width=16) (actual time=0.035..0.035 rows=72 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
41. 0.025 0.025 ↓ 1.0 72 1

Seq Scan on "ReturnAnnouncementDO" scm_retando (cost=0.00..3.70 rows=70 width=16) (actual time=0.006..0.025 rows=72 loops=1)

42. 0.000 0.067 ↓ 0.0 0 1

Subquery Scan on *SELECT* 5 (cost=8.45..17.58 rows=1 width=663) (actual time=0.067..0.067 rows=0 loops=1)

43. 0.001 0.067 ↓ 0.0 0 1

Nested Loop (cost=8.45..17.57 rows=1 width=631) (actual time=0.067..0.067 rows=0 loops=1)

44. 0.012 0.066 ↓ 0.0 0 1

Hash Join (cost=8.17..15.15 rows=1 width=592) (actual time=0.066..0.066 rows=0 loops=1)

  • Hash Cond: (rma.id = rmat."returnAnnouncementRef")
45. 0.007 0.007 ↑ 54.0 1 1

Seq Scan on "ReturnAnnouncementDO" rma (cost=0.00..6.76 rows=54 width=24) (actual time=0.007..0.007 rows=1 loops=1)

  • Filter: (("supplierRef" IS NULL) OR ("supplierRef" = ANY ('{0,1,3000,2000,1200,1000,1210,1100,10000,10005,10010,10015,10020,1211,1212,10002,10001,10003,10007,10006,10008,10012,10011,10013,10017,10016,10018,10022, (...)
46. 0.000 0.047 ↓ 0.0 0 1

Hash (cost=8.16..8.16 rows=1 width=584) (actual time=0.047..0.047 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
47. 0.047 0.047 ↓ 0.0 0 1

Index Scan using "index_ReturnAnnouncementTransmissionDO_creationDate" on "ReturnAnnouncementTransmissionDO" rmat (cost=0.14..8.16 rows=1 width=584) (actual time=0.047..0.047 rows=0 loops=1)

  • Index Cond: (("creationDate" >= '2018-05-14 16:14:53.976467'::timestamp without time zone) AND ("creationDate" <= '2019-05-16 16:14:53.975467'::timestamp without time zone))
48. 0.000 0.000 ↓ 0.0 0

Index Scan using "OrderDO_pkey" on "OrderDO" odo_4 (cost=0.28..2.41 rows=1 width=55) (never executed)

  • Index Cond: (id = rma."orderRef")
  • Filter: ("shopRef" = ANY ('{0,1,200,100,300,210,230,500,220,110,120,111,10300,10296,10384,10380,10442,10446,10518,10510,10590,10582,10301,10297,10385,10381,10445,10447,10519,10513,10591,10587}'::bigint[]))
49. 0.011 2.645 ↓ 1.3 12 1

Subquery Scan on *SELECT* 6 (cost=1.60..28.17 rows=9 width=663) (actual time=2.534..2.645 rows=12 loops=1)

50. 0.046 2.634 ↓ 1.3 12 1

Nested Loop (cost=1.60..28.08 rows=9 width=631) (actual time=2.526..2.634 rows=12 loops=1)

51. 0.037 0.164 ↑ 1.0 12 1

Hash Join (cost=1.33..9.97 rows=12 width=592) (actual time=0.104..0.164 rows=12 loops=1)

  • Hash Cond: (rt.id = rtt."returnRef")
52. 0.052 0.052 ↑ 1.0 96 1

Seq Scan on "ReturnDO" rt (cost=0.00..8.16 rows=96 width=24) (actual time=0.006..0.052 rows=96 loops=1)

  • Filter: (("supplierRef" IS NULL) OR ("supplierRef" = ANY ('{0,1,3000,2000,1200,1000,1210,1100,10000,10005,10010,10015,10020,1211,1212,10002,10001,10003,10007,10006,10008,10012,10011,10013,10017,10016,10018,10022, (...)
53. 0.011 0.075 ↑ 1.0 12 1

Hash (cost=1.18..1.18 rows=12 width=584) (actual time=0.075..0.075 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
54. 0.064 0.064 ↑ 1.0 12 1

Seq Scan on "ReturnTransmissionDO" rtt (cost=0.00..1.18 rows=12 width=584) (actual time=0.025..0.064 rows=12 loops=1)

  • Filter: (("creationDate" >= '2018-05-14 16:14:53.976467'::timestamp without time zone) AND ("creationDate" <= '2019-05-16 16:14:53.975467'::timestamp without time zone))
55. 2.424 2.424 ↑ 1.0 1 12

Index Scan using "OrderDO_pkey" on "OrderDO" odo_5 (cost=0.28..1.50 rows=1 width=55) (actual time=0.202..0.202 rows=1 loops=12)

  • Index Cond: (id = rt."orderRef")
  • Filter: ("shopRef" = ANY ('{0,1,200,100,300,210,230,500,220,110,120,111,10300,10296,10384,10380,10442,10446,10518,10510,10590,10582,10301,10297,10385,10381,10445,10447,10519,10513,10591,10587}'::bigint[]))
56. 0.000 0.004 ↓ 0.0 0 1

Subquery Scan on *SELECT* 7 (cost=0.56..18.29 rows=1 width=663) (actual time=0.004..0.004 rows=0 loops=1)

57. 0.001 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.56..18.28 rows=1 width=619) (actual time=0.004..0.004 rows=0 loops=1)

58. 0.000 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.29..16.33 rows=1 width=580) (actual time=0.003..0.003 rows=0 loops=1)

59. 0.003 0.003 ↓ 0.0 0 1

Index Scan using "index_PNTDO_cDate" on "PaymentNotificationTransmissionDO" pnt (cost=0.14..8.16 rows=1 width=580) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (("creationDate" >= '2018-05-14 16:14:53.976467'::timestamp without time zone) AND ("creationDate" <= '2019-05-16 16:14:53.975467'::timestamp without time zone))
60. 0.000 0.000 ↓ 0.0 0

Index Scan using "PaymentNotificationDO_pkey" on "PaymentNotificationDO" pn (cost=0.14..8.16 rows=1 width=16) (never executed)

  • Index Cond: (id = pnt."paymentNotificationRef")
61. 0.000 0.000 ↓ 0.0 0

Index Scan using "OrderDO_pkey" on "OrderDO" odo_6 (cost=0.28..1.93 rows=1 width=55) (never executed)

  • Index Cond: (id = pn."orderRef")
  • Filter: ("shopRef" = ANY ('{0,1,200,100,300,210,230,500,220,110,120,111,10300,10296,10384,10380,10442,10446,10518,10510,10590,10582,10301,10297,10385,10381,10445,10447,10519,10513,10591,10587}'::bigint[]))
62. 0.001 0.005 ↓ 0.0 0 1

Subquery Scan on *SELECT* 8 (cost=0.56..19.59 rows=1 width=663) (actual time=0.005..0.005 rows=0 loops=1)

63. 0.000 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.56..19.58 rows=1 width=631) (actual time=0.004..0.004 rows=0 loops=1)

64. 0.000 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.29..16.38 rows=1 width=592) (actual time=0.004..0.004 rows=0 loops=1)

65. 0.004 0.004 ↓ 0.0 0 1

Index Scan using "index_RRTDO_cDate" on "ReturnRequestTransmissionDO" rrt (cost=0.14..8.16 rows=1 width=584) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (("creationDate" >= '2018-05-14 16:14:53.976467'::timestamp without time zone) AND ("creationDate" <= '2019-05-16 16:14:53.975467'::timestamp without time zone))
66. 0.000 0.000 ↓ 0.0 0

Index Scan using "ReturnRequestDO_pkey" on "ReturnRequestDO" rr (cost=0.14..8.20 rows=1 width=24) (never executed)

  • Index Cond: (id = rrt."returnRequestRef")
  • Filter: (("supplierRef" IS NULL) OR ("supplierRef" = ANY ('{0,1,3000,2000,1200,1000,1210,1100,10000,10005,10010,10015,10020,1211,1212,10002,10001,10003,10007,10006,10008,10012,10011,10013,10017,10016,10018,10022, (...)
67. 0.000 0.000 ↓ 0.0 0

Index Scan using "OrderDO_pkey" on "OrderDO" odo_7 (cost=0.28..3.19 rows=1 width=55) (never executed)

  • Index Cond: (id = rr."orderRef")
  • Filter: ("shopRef" = ANY ('{0,1,200,100,300,210,230,500,220,110,120,111,10300,10296,10384,10380,10442,10446,10518,10510,10590,10582,10301,10297,10385,10381,10445,10447,10519,10513,10591,10587}'::bigint[]))
68. 0.000 0.003 ↓ 0.0 0 1

Subquery Scan on *SELECT* 9 (cost=0.69..17.05 rows=1 width=663) (actual time=0.003..0.003 rows=0 loops=1)

69. 0.001 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.69..17.04 rows=1 width=631) (actual time=0.003..0.003 rows=0 loops=1)

70. 0.000 0.002 ↓ 0.0 0 1

Nested Loop (cost=0.42..16.51 rows=1 width=592) (actual time=0.002..0.002 rows=0 loops=1)

71. 0.002 0.002 ↓ 0.0 0 1

Index Scan using "index_ResponseTransmissionDO_cDate" on "ResponseTransmissionDO" rspt (cost=0.14..8.16 rows=1 width=584) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (("creationDate" >= '2018-05-14 16:14:53.976467'::timestamp without time zone) AND ("creationDate" <= '2019-05-16 16:14:53.975467'::timestamp without time zone))
72. 0.000 0.000 ↓ 0.0 0

Index Scan using "ResponseDO_pkey" on "ResponseDO" rsp (cost=0.28..8.34 rows=1 width=24) (never executed)

  • Index Cond: (id = rspt."responseRef")
  • Filter: (("supplierRef" IS NULL) OR ("supplierRef" = ANY ('{0,1,3000,2000,1200,1000,1210,1100,10000,10005,10010,10015,10020,1211,1212,10002,10001,10003,10007,10006,10008,10012,10011,10013,10017,10016,10018,10022, (...)
73. 0.000 0.000 ↓ 0.0 0

Index Scan using "OrderDO_pkey" on "OrderDO" odo_8 (cost=0.28..0.52 rows=1 width=55) (never executed)

  • Index Cond: (id = rsp."orderRef")
  • Filter: ("shopRef" = ANY ('{0,1,200,100,300,210,230,500,220,110,120,111,10300,10296,10384,10380,10442,10446,10518,10510,10590,10582,10301,10297,10385,10381,10445,10447,10519,10513,10591,10587}'::bigint[]))
74. 0.000 0.003 ↓ 0.0 0 1

Subquery Scan on *SELECT* 10 (cost=0.57..17.12 rows=1 width=663) (actual time=0.003..0.003 rows=0 loops=1)

75. 0.000 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.57..17.11 rows=1 width=631) (actual time=0.003..0.003 rows=0 loops=1)

76. 0.000 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.29..16.38 rows=1 width=592) (actual time=0.003..0.003 rows=0 loops=1)

77. 0.003 0.003 ↓ 0.0 0 1

Index Scan using "index_DispatchTransmissionDO_cDate" on "DispatchTransmissionDO" dspt (cost=0.14..8.16 rows=1 width=584) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (("creationDate" >= '2018-05-14 16:14:53.976467'::timestamp without time zone) AND ("creationDate" <= '2019-05-16 16:14:53.975467'::timestamp without time zone))
78. 0.000 0.000 ↓ 0.0 0

Index Scan using "DispatchDO_pkey" on "DispatchDO" dsp (cost=0.15..8.21 rows=1 width=24) (never executed)

  • Index Cond: (id = dspt."dispatchRef")
  • Filter: (("supplierRef" IS NULL) OR ("supplierRef" = ANY ('{0,1,3000,2000,1200,1000,1210,1100,10000,10005,10010,10015,10020,1211,1212,10002,10001,10003,10007,10006,10008,10012,10011,10013,10017,10016,10018,10022, (...)
79. 0.000 0.000 ↓ 0.0 0

Index Scan using "OrderDO_pkey" on "OrderDO" odo_9 (cost=0.28..0.72 rows=1 width=55) (never executed)

  • Index Cond: (id = dsp."orderRef")
  • Filter: ("shopRef" = ANY ('{0,1,200,100,300,210,230,500,220,110,120,111,10300,10296,10384,10380,10442,10446,10518,10510,10590,10582,10301,10297,10385,10381,10445,10447,10519,10513,10591,10587}'::bigint[]))
80. 0.001 0.004 ↓ 0.0 0 1

Subquery Scan on *SELECT* 11 (cost=8.99..33.19 rows=1 width=663) (actual time=0.004..0.004 rows=0 loops=1)

81. 0.000 0.003 ↓ 0.0 0 1

Nested Loop (cost=8.99..33.18 rows=1 width=631) (actual time=0.003..0.003 rows=0 loops=1)

82. 0.000 0.003 ↓ 0.0 0 1

Nested Loop (cost=8.71..24.83 rows=1 width=592) (actual time=0.003..0.003 rows=0 loops=1)

83. 0.001 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.42..16.51 rows=1 width=592) (actual time=0.003..0.003 rows=0 loops=1)

84. 0.002 0.002 ↓ 0.0 0 1

Index Scan using "index_DocumentTransmissionDO_cDate" on "DocumentTransmissionDO" dctt (cost=0.14..8.16 rows=1 width=584) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (("creationDate" >= '2018-05-14 16:14:53.976467'::timestamp without time zone) AND ("creationDate" <= '2019-05-16 16:14:53.975467'::timestamp without time zone))
85. 0.000 0.000 ↓ 0.0 0

Index Scan using "DocumentDO_pkey" on "DocumentDO" dct (cost=0.28..8.34 rows=1 width=16) (never executed)

  • Index Cond: (id = dctt."documentRef")
  • Filter: (("supplierRef" IS NULL) OR ("supplierRef" = ANY ('{0,1,3000,2000,1200,1000,1210,1100,10000,10005,10010,10015,10020,1211,1212,10002,10001,10003,10007,10006,10008,10012,10011,10013,10017,10016,10018, (...)
86. 0.000 0.000 ↓ 0.0 0

Result (cost=8.29..8.30 rows=1 width=0) (never executed)

87.          

Initplan (forResult)

88. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.28..8.29 rows=1 width=8) (never executed)

89. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "Document2OrderDO_pkey" on "Document2OrderDO" dct2o (cost=0.28..8.29 rows=1 width=8) (never executed)

  • Index Cond: (("documentRef" = $11) AND ("orderRef" IS NOT NULL))
  • Heap Fetches: 0
90. 0.000 0.000 ↓ 0.0 0

Index Scan using "OrderDO_pkey" on "OrderDO" odo_10 (cost=0.28..8.33 rows=1 width=55) (never executed)

  • Index Cond: (id = ($12))
  • Filter: ("shopRef" = ANY ('{0,1,200,100,300,210,230,500,220,110,120,111,10300,10296,10384,10380,10442,10446,10518,10510,10590,10582,10301,10297,10385,10381,10445,10447,10519,10513,10591,10587}'::bigint[]))
91. 0.005 0.020 ↓ 4.0 40 1

Hash (cost=1.10..1.10 rows=10 width=126) (actual time=0.020..0.020 rows=40 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
92. 0.015 0.015 ↓ 4.0 40 1

Seq Scan on "SupplierDO" sup (cost=0.00..1.10 rows=10 width=126) (actual time=0.005..0.015 rows=40 loops=1)

93. 0.005 0.016 ↓ 3.0 36 1

Hash (cost=1.12..1.12 rows=12 width=126) (actual time=0.016..0.016 rows=36 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
94. 0.011 0.011 ↓ 3.0 36 1

Seq Scan on "ShopDO" shop (cost=0.00..1.12 rows=12 width=126) (actual time=0.004..0.011 rows=36 loops=1)