explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jdw2

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.008 92.859 ↓ 2.0 10 1

Limit (cost=87,865.21..87,865.23 rows=5 width=3,233) (actual time=92.837..92.859 rows=10 loops=1)

  • Output: (("Movement".document ->> 'partnerName'::text)), (("Movement".document ->> 'payerName'::text)), (("Movement".document ->> 'payerId'::text)), ((("Movement".document ->> 'rateIsReverse'::text))::boolean), (("Movement".document ->> 'id'::text)), (("Movement".document ->> 'transactionId'::text)), (("Movement".document ->> 'valueDate'::text)), (("Movement".document ->> 'description'::text)), (("Movement".document ->> 'additionalInformation'::text)), ((("Movement".document ->> 'amount'::text))::numeric), ((("Movement".document ->> 'amountCredit'::text))::numeric), ((("Movement".document ->> 'amountCreditGEL'::text))::numeric), ((("Movement".document ->> 'amountDebit'::text))::numeric), ((("Movement".document ->> 'amountDebitGEL'::text))::numeric), ((("Movement".document ->> 'chargeAmount'::text))::numeric), ((("Movement".document -> 'movementType'::text) ->> 'transTypeID'::text)), (("Movement_movementType".document -> 'text'::text)), ((("Movement".document -> 'movementType'::text) ->> 'entityUniqueId'::text)), (("Movement_movementType".document ->> 'entityType'::text)), (("Movement".document ->> 'status'::text)), ((("Movement".document -> 'currency'::text) ->> 'currencyID'::text)), ((("Movement".document -> 'currency'::text) ->> 'entityUniqueId'::text)), (("Movement_currency".document ->> 'entityType'::text)), ((("Movement".document ->> 'partnerAmount'::text))::numeric), ((("Movement".document -> 'partnerCurrency'::text) ->> 'currencyID'::text)), ((("Movement".document -> 'partnerCurrency'::text) ->> 'entityUniqueId'::text)), (("Movement_partnerCurrency".document ->> 'entityType'::text)), ((("Movement".document ->> 'rateItems'::text))::numeric), ((("Movement".document ->> 'rateAmount'::text))::numeric), (("Movement".document ->> 'altaCreditAccountName'::text)), (("Movement".document ->> 'altaDebitAccountName'::text)), (("Movement".document ->> 'senderName'::text)), (("Movement".document ->> 'senderBankCode'::text)), (("Movement".document ->> 'senderBankName'::text)), (("Movement".document ->> 'receiverName'::text)), (("Movement".document ->> 'receiverAccount'::text)), (("Movement".document ->> 'senderAccount'::text)), (("Movement".document ->> 'receiverBankName'::text)), (("Movement".document ->> 'receiverBankCode'::text)), ((("Movement".document ->> 'directionDRCR'::text))::numeric), (("Movement".document ->> 'partnerAccountIBAN'::text)), (("Movement".document ->> 'orderDate'::text)), (("Movement".document ->> 'altaDebitAccountIBAN'::text)), (("Movement".document ->> 'altaCreditAccountIBAN'::text)), ((("Movement".document ->> 'altaDebitCustomerId'::text))::numeric), ((("Movement".document ->> 'altaCreditCustomer'::text))::numeric), (((("Movement".document -> 'clientAccount'::text) ->> 'cbsID'::text))::numeric), (("Movement_clientAccount".document ->> 'friendlyName'::text)), (("Movement_clientAccount".document -> 'accountName'::text)), (("Movement_clientAccount".document ->> 'ibanAccount'::text)), (("Movement_clientAccount_customProductIcon".document ->> 'icon'::text)), ((("Movement_clientAccount".document -> 'customProductIcon'::text) ->> 'entityUniqueId'::text)), (("Movement_clientAccount_customProductIcon".document
  • ->> 'entityType'::text)), ((("Movement_clientAccount".document -> 'accountType'::text) ->> 'accTypeId'::text)), (("Movement_clientAccount_accountType".document -> 'text'::text)), (("Movement_clientAccount_accountType_defaultAccountIcon".document ->> 'icon'::text)), ((("Movement_clientAccount_accountType".document ->
  • 'defaultAccountIcon'::text) ->> 'entityUniqueId'::text)), (("Movement_clientAccount_accountType_defaultAccountIcon".document ->> 'entityType'::text)), ((("Movement_clientAccount".document -> 'accountType'::text) ->> 'entityUniqueId'::text)), (("Movement_clientAccount_accountType".document ->> 'entityType'::text)), ((("Movement".document -> 'clientAccount'::text) ->> 'entityUniqueId'::text)), (("Movement_clientAccount".document ->> 'entityType'::text)), (("Movement_partnerClientAccount".document ->> 'friendlyName'::text)), (("Movement_partnerClientAccount".document -> 'accountName'::text)), (("Movement_partnerClientAccount".document ->> 'ibanAccount'::text)), (("Movement_partnerClientAccount_customProductIcon".document ->> 'icon'::text)), ((("Movement_partnerClientAccount".document -> 'customProductIcon'::text) ->> 'entityUniqueId'::text)), (("Movement_partnerClientAccount_customProductIcon".document ->> 'entityType'::text)), ((("Movement_partnerClientAccount".document -> 'accountType'::text) ->> 'accTypeId'::text)), (("Movement_partnerClientAccount_accountType".document -> 'text'::text)), (("Movement_partnerClientAccount_accountType_defaultAccountIcon".document ->> 'icon'::text)), ((("Movement_partnerClientAccount_accountType".document -> 'defaultAccountIcon'::text) ->> 'entityUniqueId'::text)), (("Movement_partnerClientAccount_accountType_defaultAccountIcon".document ->> 'entityType'::text)), ((("Movement_partnerClientAccount".document -> 'accountType'::text) ->> 'entityUniqueId'::text)), (("Movement_partnerClientAccount_accountType".document ->> 'entityType'::text)), ((("Movement".document -> 'partnerClientAccount'::text) ->> 'entityUniqueId'::text)), (("Movement_partnerClientAccount".document ->> 'entityType'::text)), ((("Movement_bpTransaction".document ->> 'amount'::text))::numeric), (("Movement_bpTransaction".document ->> 'serviceName'::text)), (("Movement_bpTransaction".document ->> 'providerName'::text)), (("Movement_bpTransaction".document ->> 'paymentId'::text)), (("Movement_bpTransaction".document ->> 'paymentStatus'::text)), (("Movement_bpTransaction".document ->> 'customerIdentificationCode'::text)), (("Movement_bpTransaction_providerCode".document ->> 'providerIconUri'::text)), ((("Movement_bpTransaction".document -> 'providerCode'::text) ->> 'providerCode'::text)), (("Movement_bpTransaction_providerCode".document -> 'text'::text)), (("Movement_bpTransaction_providerCode".document ->> 'isLocalGlobal'::text)), ((("Movement_bpTransaction".document -> 'providerCode'::text) ->> 'entityUniqueId'::text)), (("Movement_bpTransaction_providerCode".document ->> 'entityType'::text)), (("Movement_bpTransaction_serviceCode".document ->> 'serviceIconUri'::text)), ((("Movement_bpTransaction".document -> 'serviceCode'::text) ->> 'serviceCode'::text)), ((("Movement_bpTransaction_serviceCode".document -> 'billType'::text) ->> 'billTypeKey'::text)), ((("Movement_bpTransaction_serviceCode".document -> 'billType'::text) ->> 'entityUniqueId'::text)), (("Movement_bpTransaction_serviceCode_billType".document ->> 'entityType'::text)), ((("Movement_bpTransaction".document -> 'serviceCode'::text) ->> 'entityUniqueId'::text)), (("Movement_bpTransaction_serviceCode".document ->> 'entityType'::text)), ((("Movement".document -> 'bpTransaction'::text) ->> 'entityUniqueId'::text)), (("Movement_bpTransaction".document ->> 'entityType'::text)), (("Movement".document ->> 'entityUniqueId'::text)), (("Movement".document ->> 'entityType'::text)), ((json_build_object('valueDate', ("Movement".document ->> 'valueDate'::text), 'transactionId', (("Movement".document ->> 'transactionId'::text))::numeric, 'entityUniqueId', ("Movement".document ->> 'entityUniqueId'::text)))::jsonb), ((("Movement".document ->> 'transactionId'::text))::numeric)
  • Buffers: shared hit=3,532
  • (("Movement".document ->> 'senderBankCode'::text)), (("Movement".document ->> 'senderBankName'::text)), (("Movement".document ->> 'receiverName'::text)), (("Movement".document ->> 'receiverAccount'::text)), (("Movement".document ->> 'senderAccount'::text)), (("Movement".document ->> 'receiverBankName'::text)), (("Movement".document ->> 'receiverBankCode'::text)), ((("Movement".document ->> 'directionDRCR'::text))::numeric), (("Movement".document ->> 'partnerAccountIBAN'::text)), (("Movement".document ->> 'orderDate'::text)), (("Movement".document ->> 'altaDebitAccountIBAN'::text)), (("Movement".document ->> 'altaCreditAccountIBAN'::text)), ((("Movement".document ->> 'altaDebitCustomerId'::text))::numeric), ((("Movement".document ->> 'altaCreditCustomer'::text))::numeric), (((("Movement".document -> 'clientAccount'::text) ->> 'cbsID'::text))::numeric), (("Movement_clientAccount".document ->> 'friendlyName'::text)), (("Movement_clientAccount".document -> 'accountName'::text)), (("Movement_clientAccount".document ->> 'ibanAccount'::text)), (("Movement_clientAccount_customProductIcon".document ->> 'icon'::text)), ((("Movement_clientAccount".document -> 'customProductIcon'::text) ->> 'entityUniqueId'::text)), (("Movement_clientAccount_customProductIcon".document ->> 'entityType'::text)), ((("Movement_clientAccount".document -> 'accountType'::text) ->> 'accTypeId'::text)), (("Movement_clientAccount_accountType".document -> 'text'::text)), (("Movement_clientAccount_accountType_defaultAccountIcon".document ->> 'icon'::text)), ((("Movement_clientAccount_accountType".document -> 'defaultAccountIcon'::text) ->> 'entityUniqueId'::text)), (("Movement_clientAccount_accountType_defaultAccountIcon".document ->> 'entityType'::text)), ((("Movement_clientAccount".document -> 'accountType'::text) ->> 'entityUniqueId'::text)), (("Movement_clientAccount_accountType".document ->> 'entityType'::text)), ((("Movement".document -> 'clientAccount'::text) ->> 'entityUniqueId'::text)), (("Movement_clientAccount".document ->> 'entityType'::text)), (("Movement_partnerClientAccount".document ->> 'friendlyName'::text)), (("Movement_partnerClientAccount".document -> 'accountName'::text)), (("Movement_partnerClientAccount".document ->> 'ibanAccount'::text)), (("Movement_partnerClientAccount_customProductIcon".document ->> 'icon'::text)), ((("Movement_partnerClientAccount".document -> 'customProductIcon'::text) ->> 'entityUniqueId'::text)), (("Movement_partnerClientAccount_customProductIcon".document ->> 'entityType'::text)), ((("Movement_partnerClientAccount".document -> 'accountType'::text) ->> 'accTypeId'::text)), (("Movement_partnerClientAccount_accountType".document -> 'text'::text)), (("Movement_partnerClientAccount_accountType_defaultAccountIcon".document ->> 'icon'::text)), ((("Movement_partnerClientAccount_accountType".document -> 'defaultAccountIcon'::text) ->> 'entityUniqueId'::text)), (("Movement_partnerClientAccount_accountType_defaultAccountIcon".document ->> 'entityType'::text)), ((("Movement_partnerClientAccount".document -> 'accountType'::text) ->> 'entityUniqueId'::text)), (("Movement_partnerClientAccount_accountType".document ->> 'entityType'::text)), ((("Movement".document -> 'partnerClientAccount'::text) ->> 'entityUniqueId'::text)), (("Movement_partnerClientAccount".document ->> 'entityType'::text)), ((("Movement_bpTransaction".document ->> 'amount'::text))::numeric), (("Movement_bpTransaction".document ->> 'serviceName'::text)), (("Movement_bpTransaction".document ->> 'providerName'::text)), (("Movement_bpTransaction".document ->> 'paymentId'::text)), (("Movement_bpTransaction".document ->> 'paymentStatus'::text)), (("Movement_bpTransaction".document ->> 'customerIdentificationCode'::text)), (("Movement_bpTransaction_providerCode".document ->> 'providerIconUri'::text)), ((("Movement_bpTransaction".document -> 'providerCode'::text) ->> 'providerCode'::text)), (("Movement_bpTransaction_providerCode".document -> 'text'::text)), (("Movement_bpTransaction_providerCode".document ->> 'isLocalGlobal'::text)), ((("Movement_bpTransaction".document -> 'providerCode'::text) ->> 'entityUniqueId'::text)), (("Movement_bpTransaction_providerCode".document ->> 'entityType'::text)), (("Movement_bpTransaction_serviceCode".document ->> 'serviceIconUri'::text)), ((("Movement_bpTransaction".document -> 'serviceCode'::text) ->> 'serviceCode'::text)), ((("Movement_bpTransaction_serviceCode".document -> 'billType'::text) ->> 'billTypeKey'::text)), ((("Movement_bpTransaction_serviceCode".document -> 'billType'::text) ->> 'entityUniqueId'::text)), (("Movement_bpTransaction_serviceCode_billType".document ->> 'entityType'::text)), ((("Movement_bpTransaction".document -> 'serviceCode'::text) ->> 'entityUniqueId'::text)), (("Movement_bpTransaction_serviceCode".document ->> 'entityType'::text)), ((("Movement".document -> 'bpTransaction'::text) ->> 'entityUniqueId'::text)), (("Movement_bpTransaction".document ->> 'entityType'::text)), (("Movement".document ->> 'entityUniqueId'::text)), (("Movement".document ->> 'entityType'::text)), ((json_build_object('valueDate', ("Movement".document ->> 'valueDate'::text), 'transactionId', (("Movement".document ->> 'transactionId'::text))::numeric, 'entityUniqueId', ("Movement".document ->> 'entityUniqueId'::text)))::jsonb), ((("Movement".document ->> 'transactionId'::text))::numeric)
  • (("Movement_bpTransaction".document -> 'serviceCode'::text) ->> 'serviceCode'::text), (("Movement_bpTransaction_serviceCode".document -> 'billType'::text) ->> 'billTypeKey'::text), (("Movement_bpTransaction_serviceCode".document -> 'billType'::text) ->> 'entityUniqueId'::text), ("Movement_bpTransaction_serviceCode_billType".document ->> 'entityType'::text), (("Movement_bpTransaction".document -> 'serviceCode'::text) ->> 'entityUniqueId'::text), ("Movement_bpTransaction_serviceCode".document ->> 'entityType'::text), (("Movement".document -> 'bpTransaction'::text) ->> 'entityUniqueId'::text), ("Movement_bpTransaction".document ->> 'entityType'::text), ("Movement".document ->> 'entityUniqueId'::text), ("Movement".document ->> 'entityType'::text), (json_build_object('valueDate', ("Movement".document ->> 'valueDate'::text), 'transactionId', (("Movement".document ->> 'transactionId'::text))::numeric, 'entityUniqueId', ("Movement".document ->> 'entityUniqueId'::text)))::jsonb, (("Movement".document ->> 'transactionId'::text))::numeric
  • OR (((("Movement".document -> 'movementType'::text) ->> 'entityUniqueId'::text) = 'TCFastMoneyTransfer'::text) AND ((("Movement".document ->> 'altaCreditCustomer'::text))::numeric = '993639'::numeric) AND ((("Movement".document ->> 'directionDRCR'::text))::numeric = '1'::numeric)) OR (((("Movement".document -> 'movementType'::text) ->> 'entityUniqueId'::text) = ANY ('{TCDepositOperation,TCPaymentByCard,TCCashOperation,TCFastMoneyTransfer,TCLoanOperation,TCSMSCashout,TCOther}'::text[])) AND ((("Movement_partnerClientAccount".document -> 'accountType'::text) ->> 'accTypeId'::text) = ANY ('{1,2,4,8,16,64,128}'::text[])) AND ((("Movement".document ->> 'directionDRCR'::text))::numeric = '0'::numeric)) OR (((("Movement".document -> 'movementType'::text) ->> 'entityUniqueId'::text) = ANY ('{TCDepositOperation,TCPaymentByCard,TCCashOperation,TCFastMoneyTransfer,TCLoanOperation,TCSMSCashout,TCOther}'::text[])) AND ((("Movement_partnerClientAccount".document -> 'accountType'::text) ->> 'accTypeId'::text) IS NULL) AND ((("Movement".document ->> 'directionDRCR'::text))::numeric = '0'::numeric)) OR (((("Movement".document -> 'movementType'::text) ->> 'entityUniqueId'::text) = 'TCOtherAccountIncoming'::text) AND ((("Movement".document ->> 'directionDRCR'::text))::numeric = '0'::numeric)))
2. 0.503 92.851 ↓ 2.0 10 1

Sort (cost=87,865.21..87,865.23 rows=5 width=3,233) (actual time=92.831..92.851 rows=10 loops=1)

  • Output: (("Movement".document ->> 'partnerName'::text)), (("Movement".document ->> 'payerName'::text)), (("Movement".document ->> 'payerId'::text)), ((("Movement".document ->> 'rateIsReverse'::text))::boolean), (("Movement".document ->> 'id'::text)), (("Movement".document ->> 'transactionId'::text)), (("Movement".document ->> 'valueDate'::text)), (("Movement".document ->> 'description'::text)), (("Movement".document ->> 'additionalInformation'::text)), ((("Movement".document ->> 'amount'::text))::numeric), ((("Movement".document ->> 'amountCredit'::text))::numeric), ((("Movement".document ->> 'amountCreditGEL'::text))::numeric), ((("Movement".document ->> 'amountDebit'::text))::numeric), ((("Movement".document ->> 'amountDebitGEL'::text))::numeric), ((("Movement".document ->> 'chargeAmount'::text))::numeric), ((("Movement".document -> 'movementType'::text) ->> 'transTypeID'::text)), (("Movement_movementType".document -> 'text'::text)), ((("Movement".document -> 'movementType'::text) ->> 'entityUniqueId'::text)), (("Movement_movementType".document ->> 'entityType'::text)), (("Movement".document ->> 'status'::text)), ((("Movement".document -> 'currency'::text) ->> 'currencyID'::text)), ((("Movement".document -> 'currency'::text) ->> 'entityUniqueId'::text)), (("Movement_currency".document ->> 'entityType'::text)), ((("Movement".document ->> 'partnerAmount'::text))::numeric), ((("Movement".document -> 'partnerCurrency'::text) ->> 'currencyID'::text)), ((("Movement".document -> 'partnerCurrency'::text) ->> 'entityUniqueId'::text)), (("Movement_partnerCurrency".document ->> 'entityType'::text)), ((("Movement".document ->> 'rateItems'::text))::numeric), ((("Movement".document ->> 'rateAmount'::text))::numeric), (("Movement".document ->> 'altaCreditAccountName'::text)), (("Movement".document ->> 'altaDebitAccountName'::text)), (("Movement".document ->> 'senderName'::text)),
  • Sort Key: (("Movement".document ->> 'valueDate'::text)) DESC, ((("Movement".document ->> 'transactionId'::text))::numeric) DESC, (("Movement".document ->> 'entityUniqueId'::text))
  • Sort Method: top-N heapsort Memory: 47kB
  • Buffers: shared hit=3,532
3. 14.722 92.348 ↓ 14.0 70 1

Nested Loop Left Join (cost=1.73..87,865.16 rows=5 width=3,233) (actual time=16.195..92.348 rows=70 loops=1)

  • Output: ("Movement".document ->> 'partnerName'::text), ("Movement".document ->> 'payerName'::text), ("Movement".document ->> 'payerId'::text), (("Movement".document ->> 'rateIsReverse'::text))::boolean, ("Movement".document ->> 'id'::text), ("Movement".document ->> 'transactionId'::text), ("Movement".document ->> 'valueDate'::text), ("Movement".document ->> 'description'::text), ("Movement".document ->> 'additionalInformation'::text), (("Movement".document ->> 'amount'::text))::numeric, (("Movement".document ->> 'amountCredit'::text))::numeric, (("Movement".document ->> 'amountCreditGEL'::text))::numeric, (("Movement".document ->> 'amountDebit'::text))::numeric, (("Movement".document ->> 'amountDebitGEL'::text))::numeric, (("Movement".document ->> 'chargeAmount'::text))::numeric, (("Movement".document -> 'movementType'::text) ->> 'transTypeID'::text), ("Movement_movementType".document -> 'text'::text), (("Movement".document -> 'movementType'::text) ->> 'entityUniqueId'::text), ("Movement_movementType".document ->> 'entityType'::text), ("Movement".document ->> 'status'::text), (("Movement".document -> 'currency'::text) ->> 'currencyID'::text), (("Movement".document -> 'currency'::text) ->> 'entityUniqueId'::text), ("Movement_currency".document ->> 'entityType'::text), (("Movement".document ->> 'partnerAmount'::text))::numeric, (("Movement".document -> 'partnerCurrency'::text) ->> 'currencyID'::text), (("Movement".document -> 'partnerCurrency'::text) ->> 'entityUniqueId'::text), ("Movement_partnerCurrency".document ->> 'entityType'::text), (("Movement".document ->> 'rateItems'::text))::numeric, (("Movement".document ->> 'rateAmount'::text))::numeric, ("Movement".document ->> 'altaCreditAccountName'::text), ("Movement".document ->> 'altaDebitAccountName'::text), ("Movement".document ->> 'senderName'::text), ("Movement".document ->> 'senderBankCode'::text), ("Movement".document ->> 'senderBankName'::text), ("Movement".document ->> 'receiverName'::text), ("Movement".document ->> 'receiverAccount'::text), ("Movement".document ->> 'senderAccount'::text), ("Movement".document ->> 'receiverBankName'::text), ("Movement".document ->> 'receiverBankCode'::text), (("Movement".document ->> 'directionDRCR'::text))::numeric, ("Movement".document ->> 'partnerAccountIBAN'::text), ("Movement".document ->> 'orderDate'::text), ("Movement".document ->> 'altaDebitAccountIBAN'::text), ("Movement".document ->> 'altaCreditAccountIBAN'::text), (("Movement".document ->> 'altaDebitCustomerId'::text))::numeric, (("Movement".document ->> 'altaCreditCustomer'::text))::numeric, ((("Movement".document -> 'clientAccount'::text) ->> 'cbsID'::text))::numeric, ("Movement_clientAccount".document ->> 'friendlyName'::text), ("Movement_clientAccount".document -> 'accountName'::text), ("Movement_clientAccount".document ->> 'ibanAccount'::text), ("Movement_clientAccount_customProductIcon".document ->> 'icon'::text), (("Movement_clientAccount".document -> 'customProductIcon'::text) ->> 'entityUniqueId'::text), ("Movement_clientAccount_customProductIcon".document ->> 'entityType'::text), (("Movement_clientAccount".document -> 'accountType'::text) ->> 'accTypeId'::text), ("Movement_clientAccount_accountType".document -> 'text'::text), ("Movement_clientAccount_accountType_defaultAccountIcon".document ->> 'icon'::text), (("Movement_clientAccount_accountType".document -> 'defaultAccountIcon'::text) ->> 'entityUniqueId'::text), ("Movement_clientAccount_accountType_defaultAccountIcon".document ->> 'entityType'::text), (("Movement_clientAccount".document -> 'accountType'::text) ->> 'entityUniqueId'::text), ("Movement_clientAccount_accountType".document ->> 'entityType'::text), (("Movement".document -> 'clientAccount'::text) ->> 'entityUniqueId'::text), ("Movement_clientAccount".document ->> 'entityType'::text), ("Movement_partnerClientAccount".document ->> 'friendlyName'::text), ("Movement_partnerClientAccount".document -> 'accountName'::text), ("Movement_partnerClientAccount".document ->> 'ibanAccount'::text), ("Movement_partnerClientAccount_customProductIcon".document ->> 'icon'::text), (("Movement_partnerClientAccount".document -> 'customProductIcon'::text) ->> 'entityUniqueId'::text), ("Movement_partnerClientAccount_customProductIcon".document ->> 'entityType'::text), (("Movement_partnerClientAccount".document -> 'accountType'::text) ->> 'accTypeId'::text), ("Movement_partnerClientAccount_accountType".document -> 'text'::text), ("Movement_partnerClientAccount_accountType_defaultAccountIcon".document ->> 'icon'::text), (("Movement_partnerClientAccount_accountType".document -> 'defaultAccountIcon'::text) ->> 'entityUniqueId'::text), ("Movement_partnerClientAccount_accountType_defaultAccountIcon".document ->> 'entityType'::text), (("Movement_partnerClientAccount".document -> 'accountType'::text) ->> 'entityUniqueId'::text), ("Movement_partnerClientAccount_accountType".document ->> 'entityType'::text), (("Movement".document -> 'partnerClientAccount'::text) ->> 'entityUniqueId'::text), ("Movement_partnerClientAccount".document ->> 'entityType'::text), (("Movement_bpTransaction".document ->> 'amount'::text))::numeric, ("Movement_bpTransaction".document ->> 'serviceName'::text), ("Movement_bpTransaction".document ->> 'providerName'::text), ("Movement_bpTransaction".document ->> 'paymentId'::text), ("Movement_bpTransaction".document ->> 'paymentStatus'::text), ("Movement_bpTransaction".document ->> 'customerIdentificationCode'::text), ("Movement_bpTransaction_providerCode".document ->> 'providerIconUri'::text), (("Movement_bpTransaction".document -> 'providerCode'::text) ->> 'providerCode'::text), ("Movement_bpTransaction_providerCode".document -> 'text'::text), ("Movement_bpTransaction_providerCode".document ->> 'isLocalGlobal'::text), (("Movement_bpTransaction".document -> 'providerCode'::text) ->> 'entityUniqueId'::text), ("Movement_bpTransaction_providerCode".document ->> 'entityType'::text), ("Movement_bpTransaction_serviceCode".document ->> 'serviceIconUri'::text),
  • Inner Unique: true
  • Join Filter: ((("Movement_bpTransaction_serviceCode".document -> 'billType'::text) ->> 'entityUniqueId'::text) = ("Movement_bpTransaction_serviceCode_billType".entityuniqueid)::text)
  • Rows Removed by Join Filter: 324
  • Buffers: shared hit=3,526
4. 2.645 77.556 ↓ 14.0 70 1

Nested Loop Left Join (cost=1.73..87,861.92 rows=5 width=10,580) (actual time=15.689..77.556 rows=70 loops=1)

  • Output: "Movement".document, "Movement_movementType".document, "Movement_currency".document, "Movement_partnerCurrency".document, "Movement_clientAccount".document, "Movement_clientAccount_customProductIcon".document, "Movement_clientAccount_accountType".document, "Movement_clientAccount_accountType_defaultAccountIcon".document, "Movement_partnerClientAccount".document, "Movement_partnerClientAccount_customProductIcon".document, "Movement_partnerClientAccount_accountType".document, "Movement_partnerClientAccount_accountType_defaultAccountIcon".document, "Movement_bpTransaction".document, "Movement_bpTransaction_providerCode".document, "Movement_bpTransaction_serviceCode".document
  • Inner Unique: true
  • Join Filter: ((("Movement_bpTransaction".document -> 'serviceCode'::text) ->> 'entityUniqueId'::text) = ("Movement_bpTransaction_serviceCode".entityuniqueid)::text)
  • Rows Removed by Join Filter: 24,270
  • Buffers: shared hit=3,525
5. 1.399 72.181 ↓ 14.0 70 1

Nested Loop Left Join (cost=1.73..87,798.21 rows=5 width=9,456) (actual time=15.571..72.181 rows=70 loops=1)

  • Output: "Movement".document, "Movement_movementType".document, "Movement_currency".document, "Movement_partnerCurrency".document, "Movement_clientAccount".document, "Movement_clientAccount_customProductIcon".document, "Movement_clientAccount_accountType".document, "Movement_clientAccount_accountType_defaultAccountIcon".document, "Movement_partnerClientAccount".document, "Movement_partnerClientAccount_customProductIcon".document, "Movement_partnerClientAccount_accountType".document, "Movement_partnerClientAccount_accountType_defaultAccountIcon".document, "Movement_bpTransaction".document, "Movement_bpTransaction_providerCode".document
  • Inner Unique: true
  • Join Filter: ((("Movement_bpTransaction".document -> 'providerCode'::text) ->> 'entityUniqueId'::text) = ("Movement_bpTransaction_providerCode".entityuniqueid)::text)
  • Rows Removed by Join Filter: 11,894
  • Buffers: shared hit=3,467
6. 0.361 69.942 ↓ 14.0 70 1

Nested Loop Left Join (cost=1.73..87,785.54 rows=5 width=9,046) (actual time=15.308..69.942 rows=70 loops=1)

  • Output: "Movement".document, "Movement_movementType".document, "Movement_currency".document, "Movement_partnerCurrency".document, "Movement_clientAccount".document, "Movement_clientAccount_customProductIcon".document, "Movement_clientAccount_accountType".document, "Movement_clientAccount_accountType_defaultAccountIcon".document, "Movement_partnerClientAccount".document, "Movement_partnerClientAccount_customProductIcon".document, "Movement_partnerClientAccount_accountType".document, "Movement_partnerClientAccount_accountType_defaultAccountIcon".document, "Movement_bpTransaction".document
  • Inner Unique: true
  • Buffers: shared hit=3,457
7. 0.416 69.301 ↓ 14.0 70 1

Nested Loop Left Join (cost=1.44..87,773.35 rows=5 width=8,280) (actual time=15.270..69.301 rows=70 loops=1)

  • Output: "Movement".document, "Movement_movementType".document, "Movement_currency".document, "Movement_partnerCurrency".document, "Movement_clientAccount".document, "Movement_clientAccount_customProductIcon".document, "Movement_clientAccount_accountType".document, "Movement_clientAccount_accountType_defaultAccountIcon".document, "Movement_partnerClientAccount".document, "Movement_partnerClientAccount_customProductIcon".document, "Movement_partnerClientAccount_accountType".document, "Movement_partnerClientAccount_accountType_defaultAccountIcon".document
  • Inner Unique: true
  • Join Filter: ((("Movement_partnerClientAccount".document -> 'customProductIcon'::text) ->> 'entityUniqueId'::text) = ("Movement_partnerClientAccount_customProductIcon".entityuniqueid)::text)
  • Rows Removed by Join Filter: 3,640
  • Buffers: shared hit=3,425
8. 0.187 68.605 ↓ 14.0 70 1

Nested Loop Left Join (cost=1.44..87,769.47 rows=5 width=7,982) (actual time=15.213..68.605 rows=70 loops=1)

  • Output: "Movement".document, "Movement_movementType".document, "Movement_currency".document, "Movement_partnerCurrency".document, "Movement_clientAccount".document, "Movement_clientAccount_customProductIcon".document, "Movement_clientAccount_accountType".document, "Movement_clientAccount_accountType_defaultAccountIcon".document, "Movement_partnerClientAccount".document, "Movement_partnerClientAccount_accountType".document, "Movement_partnerClientAccount_accountType_defaultAccountIcon".document
  • Join Filter: ((("Movement_partnerClientAccount".document -> 'accountType'::text) ->> 'entityUniqueId'::text) = ("Movement_partnerClientAccount_accountType".entityuniqueid)::text)
  • Rows Removed by Join Filter: 834
  • Buffers: shared hit=3,422
9. 1.632 68.208 ↓ 14.0 70 1

Nested Loop Left Join (cost=1.44..87,764.39 rows=5 width=7,204) (actual time=15.056..68.208 rows=70 loops=1)

  • Output: "Movement".document, "Movement_movementType".document, "Movement_currency".document, "Movement_partnerCurrency".document, "Movement_clientAccount".document, "Movement_clientAccount_customProductIcon".document, "Movement_clientAccount_accountType".document, "Movement_clientAccount_accountType_defaultAccountIcon".document, "Movement_partnerClientAccount".document
  • Inner Unique: true
  • Join Filter: ((("Movement".document -> 'partnerClientAccount'::text) ->> 'entityUniqueId'::text) = ANY ('{GE55VT2900000002184405,10135158,10851367,GE75VT2900001344891801,GE35VT2900001359271801,GE82VT2900000166544405,GE24VT2900000015668351,GE64VT2900000098821851,9627846,16720585,GE46VT2900000105971851,GE42VT2900000066223651,GE81VT2900000002888351,GE33VT2900001544184101,GE97VT2900000043681801,9455211,GE24VT2900000002088351,GE09VT2900000010623651,10851368,14002409,8936786,GE23VT2900000037028351,9529630,GE90VT2900000046358351,9816769,16114825,GE17VT2900000134864405,GE11VT2900000260344101,10427411,GE44VT2900001088461801,GE24VT2900000017981801,11564518,12094156,16038106,GE78VT2900000016528351,8936765,GE34VT2900000002604405,11564516,9403386,10825849,GE12VT2900000009118351,12094157,11564517,10376857,12230057,10851366,GE94VT2900000178174101,GE20VT9900001586774101,10608208,GE66VT2900000218504101,GE95VT2900000000834415,10376856,GE77VT2900000053154405,9462931,8936787,12165866,10074355,GE87VT2900000037688351,GE86VT2900000045943651,GE84VT2900000005484405,GE45VT2900000051613651,GE49VT2900000078693651,12959303,GE52VT2900000117674405,9153516,9403388,10074354,13995407,GE19VT2900000075311801,11330531,GE61VT2900000006198351,10606877,GE84VT2900001471542405,10611017,8936785,10427410,GE42VT9900000631441851,16092516,12958303,GE20VT2900000118314405,12094155,10090794,GE91VT2900001896104101,GE48VT2900000099083651,12165868,GE38VT2900000199664101,8310268,16114824,12230077,GE52VT2900000016078351,GE89VT2900001000361905,GE09VT2900000099863651,GE42VT2900000064283651,GE27VT2900000029188351,GE05VT2900000495543601,GE84VT2900000004768351,9627847,GE28VT2900000103604405,16789609,9837848,GE06VT2900000047068351,GE46VT2900000252854101,9863744,10074353,GE42VT2900000121411801,11354159,GE77VT2900000244632405,GE75VT1000001168084506,GE34VT2900000250342405,12230078,10135156,GE67VT2900000208942405,11436003,GE83VT1000001311484506,9403387,9153518,GE46VT2900000147864405,GE76VT2900000075243651,GE28VT2900000045163651,GE89VT2900000000713661,GE66VT2900000000753651,16826399,11354160,9153482,GE57VT2900000005474415,9153517,GE91VT2900000037113651,9475062,9851449,16826398,GE90VT2900000008528351,10090795,GE87VT2900001453052405,16724456,GE47VT2900000009863651,16721033,9851451,GE02VT2900000030163651,16666018,16114823,GE77VT2900001288194101,10376855,GE05VT2900000101941851,12165867,GE27VT2900000005908351,GE77VT2900001465862405,GE19VT2900000019648351,10825850,GE87VT2900000053924405,GE08VT2900000144744405,9455212,GE86VT2900000062491851,16194136,GE81VT2900000112061851,16789608,GE30VT2900000061114101,GE93VT2900000021212405,9433570,9455466,9462930,GE26VT2900001862484101,11871863,GE63VT2900000004693651,16789607,GE64VT2900000112972405,GE68VT2900000022524101,GE10VT2900001836614101,9851450,GE33VT2900000080041851,GE72VT2900000121384101,GE59VT2900000032174405,GE76VT2900000011464405,9455467,11400303,GE89VT2900000001263651,GE44VT2900001876674101,10825848,16629004,GE46VT2900001333831801,9455465,9455210,16045208,GE96VT2900001183212405,GE89VT2900000192012405,9627845,11330532,GE88VT2900000167394405,GE53VT2900000064063651,GE28VT2900001157751905,16629304,9433568,9475061,9863745,GE16VT2900000004113661,GE70VT2900001483462405,GE56VT2900000002418351,GE83VT2900000050853651,GE09VT2900000029053651,GE86VT2900000112771801,GE35VT2900000055352405,GE28VT2900000134644405,GE16VT2900000026498351,14230993,GE74VT2900000010534405,16093865,GE77VT2900000136574405,GE39VT2900001430732405,16645556,10135157,9863743,GE74VT2900000021458351,9433569,9817727,16092453,11400288,10090796,9462929,GE49VT2900000976572405,GE22VT2900000095721905,9475060,10427409,GE40VT2900001883544101,GE30VT2900000110354405,11400304,11854065,11330530,11855910,11354161,16826397,12972718,GE98VT2900000168552405,9153515,GE35VT2900001000471905}'::text[]))
  • Rows Removed by Join Filter: 8
  • Filter: ((((("Movement".document -> 'movementType'::text) ->> 'entityUniqueId'::text) = ANY ('{TCDepositOperation,TCPaymentByCard,TCLoanOperation,TCSMSCashout,TCOther,TCBillPayment,TCATMCashout,TCFee,TCTreasury,TCCurrencyExchange,TCOtherAccountOutgoing,TCOwnAccount}'::text[])) AND ((("Movement".document ->> 'directionDRCR'::text))::numeric = '1'::numeric)) OR (((("Movement".document -> 'movementType'::text) ->> 'entityUniqueId'::text) = 'TCCashOperation'::text) AND ((("Movement".document ->> 'altaCreditCustomer'::text))::numeric <> '993639'::numeric) AND ((("Movement".document ->> 'directionDRCR'::text))::numeric = '1'::numeric)) OR (((("Movement".document -> 'movementType'::text) ->> 'entityUniqueId'::text) = 'TCCashOperation'::text) AND ((("Movement".document ->> 'altaCreditCustomer'::text))::numeric IS NULL) AND ((("Movement".document ->> 'directionDRCR'::text))::numeric = '1'::numeric))
  • Rows Removed by Filter: 5
  • Buffers: shared hit=3,407
10. 1.021 64.926 ↓ 9.4 75 1

Nested Loop Left Join (cost=1.00..87,739.15 rows=8 width=5,704) (actual time=12.118..64.926 rows=75 loops=1)

  • Output: "Movement".document, "Movement_movementType".document, "Movement_currency".document, "Movement_partnerCurrency".document, "Movement_clientAccount".document, "Movement_clientAccount_customProductIcon".document, "Movement_clientAccount_accountType".document, "Movement_clientAccount_accountType_defaultAccountIcon".document
  • Inner Unique: true
  • Join Filter: ((("Movement_clientAccount".document -> 'customProductIcon'::text) ->> 'entityUniqueId'::text) = ("Movement_clientAccount_customProductIcon".entityuniqueid)::text)
  • Rows Removed by Join Filter: 3,900
  • Buffers: shared hit=3,163
11. 13.440 63.605 ↓ 9.4 75 1

Nested Loop Left Join (cost=1.00..87,735.21 rows=8 width=5,406) (actual time=12.042..63.605 rows=75 loops=1)

  • Output: "Movement".document, "Movement_movementType".document, "Movement_currency".document, "Movement_partnerCurrency".document, "Movement_clientAccount".document, "Movement_clientAccount_accountType".document, "Movement_clientAccount_accountType_defaultAccountIcon".document
  • Inner Unique: true
  • Join Filter: ((("Movement".document -> 'partnerCurrency'::text) ->> 'entityUniqueId'::text) = ("Movement_partnerCurrency".entityuniqueid)::text)
  • Rows Removed by Join Filter: 3,900
  • Buffers: shared hit=3,160
12. 5.288 49.790 ↓ 9.4 75 1

Nested Loop Left Join (cost=1.00..87,729.27 rows=8 width=4,743) (actual time=11.721..49.790 rows=75 loops=1)

  • Output: "Movement".document, "Movement_movementType".document, "Movement_currency".document, "Movement_clientAccount".document, "Movement_clientAccount_accountType".document, "Movement_clientAccount_accountType_defaultAccountIcon".document
  • Inner Unique: true
  • Join Filter: ((("Movement".document -> 'currency'::text) ->> 'entityUniqueId'::text) = ("Movement_currency".entityuniqueid)::text)
  • Rows Removed by Join Filter: 1,425
  • Buffers: shared hit=3,155
13. 2.258 44.352 ↓ 9.4 75 1

Nested Loop Left Join (cost=1.00..87,723.32 rows=8 width=4,080) (actual time=11.556..44.352 rows=75 loops=1)

  • Output: "Movement".document, "Movement_movementType".document, "Movement_clientAccount".document, "Movement_clientAccount_accountType".document, "Movement_clientAccount_accountType_defaultAccountIcon".document
  • Inner Unique: true
  • Join Filter: ((("Movement".document -> 'movementType'::text) ->> 'entityUniqueId'::text) = ("Movement_movementType".entityuniqueid)::text)
  • Rows Removed by Join Filter: 541
  • Buffers: shared hit=3,153
14. 0.415 42.019 ↓ 9.4 75 1

Nested Loop Left Join (cost=1.00..87,721.94 rows=8 width=3,612) (actual time=11.454..42.019 rows=75 loops=1)

  • Output: "Movement".document, "Movement_clientAccount".document, "Movement_clientAccount_accountType".document, "Movement_clientAccount_accountType_defaultAccountIcon".document
  • Join Filter: ((("Movement_clientAccount".document -> 'accountType'::text) ->> 'entityUniqueId'::text) = ("Movement_clientAccount_accountType".entityuniqueid)::text)
  • Rows Removed by Join Filter: 825
  • Buffers: shared hit=3,152
15. 0.532 41.379 ↓ 9.4 75 1

Nested Loop (cost=1.00..87,716.80 rows=8 width=2,834) (actual time=11.348..41.379 rows=75 loops=1)

  • Output: "Movement".document, "Movement_clientAccount".document
  • Inner Unique: true
  • Buffers: shared hit=3,137
16. 39.671 39.671 ↓ 3.4 84 1

Index Scan using g_movements_clientaccount_entityuniqueid_s on gds.movements "Movement" (cost=0.57..87,650.17 rows=25 width=1,334) (actual time=3.552..39.671 rows=84 loops=1)

  • Output: "Movement".entityuniqueid, "Movement".sequenceno, "Movement".document
  • Index Cond: (((("Movement".document -> 'clientAccount'::text) ->> 'entityUniqueId'::text) = ANY ('{GE55VT2900000002184405,10135158,10851367,GE75VT2900001344891801,GE35VT2900001359271801,GE82VT2900000166544405,GE24VT2900000015668351,GE64VT2900000098821851,9627846,16720585,GE46VT2900000105971851,GE42VT2900000066223651,GE81VT2900000002888351,GE33VT2900001544184101,GE97VT2900000043681801,9455211,GE24VT2900000002088351,GE09VT2900000010623651,10851368,14002409,8936786,GE23VT2900000037028351,9529630,GE90VT2900000046358351,9816769,16114825,GE17VT2900000134864405,GE11VT2900000260344101,10427411,GE44VT2900001088461801,GE24VT2900000017981801,11564518,12094156,16038106,GE78VT2900000016528351,8936765,GE34VT2900000002604405,11564516,9403386,10825849,GE12VT2900000009118351,12094157,11564517,10376857,12230057,10851366,GE94VT2900000178174101,GE20VT9900001586774101,10608208,GE66VT2900000218504101,GE95VT2900000000834415,10376856,GE77VT2900000053154405,9462931,8936787,12165866,10074355,GE87VT2900000037688351,GE86VT2900000045943651,GE84VT2900000005484405,GE45VT2900000051613651,GE49VT2900000078693651,12959303,GE52VT2900000117674405,9153516,9403388,10074354,13995407,GE19VT2900000075311801,11330531,GE61VT2900000006198351,10606877,GE84VT2900001471542405,10611017,8936785,10427410,GE42VT9900000631441851,16092516,12958303,GE20VT2900000118314405,12094155,10090794,GE91VT2900001896104101,GE48VT2900000099083651,12165868,GE38VT2900000199664101,8310268,16114824,12230077,GE52VT2900000016078351,GE89VT2900001000361905,GE09VT2900000099863651,GE42VT2900000064283651,GE27VT2900000029188351,GE05VT2900000495543601,GE84VT2900000004768351,9627847,GE28VT2900000103604405,16789609,9837848,GE06VT2900000047068351,GE46VT2900000252854101,9863744,10074353,GE42VT2900000121411801,11354159,GE77VT2900000244632405,GE75VT1000001168084506,GE34VT2900000250342405,12230078,10135156,GE67VT2900000208942405,11436003,GE83VT1000001311484506,9403387,9153518,GE46VT2900000147864405,GE76VT2900000075243651,GE28VT2900000045163651,GE89VT2900000000713661,GE66VT2900000000753651,16826399,11354160,9153482,GE57VT2900000005474415,9153517,GE91VT2900000037113651,9475062,9851449,16826398,GE90VT2900000008528351,10090795,GE87VT2900001453052405,16724456,GE47VT2900000009863651,16721033,9851451,GE02VT2900000030163651,16666018,16114823,GE77VT2900001288194101,10376855,GE05VT2900000101941851,12165867,GE27VT2900000005908351,GE77VT2900001465862405,GE19VT2900000019648351,10825850,GE87VT2900000053924405,GE08VT2900000144744405,9455212,GE86VT2900000062491851,16194136,GE81VT2900000112061851,16789608,GE30VT2900000061114101,GE93VT2900000021212405,9433570,9455466,9462930,GE26VT2900001862484101,11871863,GE63VT2900000004693651,16789607,GE64VT2900000112972405,GE68VT2900000022524101,GE10VT2900001836614101,9851450,GE33VT2900000080041851,GE72VT2900000121384101,GE59VT2900000032174405,GE76VT2900000011464405,9455467,11400303,GE89VT2900000001263651,GE44VT2900001876674101,10825848,16629004,GE46VT2900001333831801,9455465,9455210,16045208,GE96VT2900001183212405,GE89VT2900000192012405,9627845,11330532,GE88VT2900000167394405,GE53VT2900000064063651,GE28VT2900001157751905,16629304,9433568,9475061,9863745,GE16VT2900000004113661,GE70VT2900001483462405,GE56VT2900000002418351,GE83VT2900000050853651,GE09VT2900000029053651,GE86VT2900000112771801,GE35VT2900000055352405,GE28VT2900000134644405,GE16VT2900000026498351,14230993,GE74VT2900000010534405,16093865,GE77VT2900000136574405,GE39VT2900001430732405,16645556,10135157,9863743,GE74VT2900000021458351,9433569,9817727,16092453,11400288,10090796,9462929,GE49VT2900000976572405,GE22VT2900000095721905,9475060,10427409,GE40VT2900001883544101,GE30VT2900000110354405,11400304,11854065,11330530,11855910,11354161,16826397,12972718,GE98VT2900000168552405,9153515,GE35VT2900001000471905}'::text[])) AND ((("Movement".document -> 'clientAccount'::text) ->> 'entityUniqueId'::text) = ANY ('{GE28VT2900001157751905,GE33VT2900001544184101,12165868,GE98VT2900000168552405,10611017,10851366,GE74VT2900000021458351,11854065,GE59VT2900000032174405,GE68VT2900000022524101,GE82VT2900000166544405,GE53VT2900000064063651,9627845,GE35VT2900001000471905,GE93VT2900000021212405,GE86VT2900000112771801,GE28VT2900000103604405,8936765,GE22VT2900000095721905,GE87VT2900000037688351,GE88VT2900000167394405,9863745,16826399,16645556,11855910,GE89VT2900000192012405,9475062,GE33VT2900000080041851,9455211,16092453,GE90VT2900000008528351,16826397,16114825,9863744,GE89VT2900000001263651,10606877,GE81VT2900000002888351,GE91VT2900001896104101,10825849,GE05VT2900000495543601,GE46VT2900000252854101,12165866,9627847,9851449,11330531,9455467,GE76VT2900000011464405,GE39VT2900001430732405,GE97VT2900000043681801,GE20VT9900001586774101,9403386,9851450,GE09VT2900000010623651,9153518,9153515,10427411,9462931,GE16VT2900000026498351,16629304,GE27VT2900000005908351,12958303,GE46VT2900000105971851,12972718,16789608,14002409,9455210,GE10VT2900001836614101,GE78VT2900000016528351,12165867,16720585,GE94VT2900000178174101,GE89VT2900000000713661,GE77VT2900000053154405,10427410,11354159,GE34VT2900000250342405,9455465,10851368,GE63VT2900000004693651,GE28VT2900000045163651,9627846,10427409,9837848,GE75VT2900001344891801,9475061,10825850,9462930,GE70VT2900001483462405,11400303,8310268,GE24VT2900000015668351,GE46VT2900001333831801,10376855,GE86VT2900000045943651,GE76VT2900000075243651,GE90VT2900000046358351,10090795,GE05VT2900000101941851,11330532,9433570,GE42VT9900000631441851,GE84VT2900000005484405,GE84VT2900001471542405,GE11VT2900000260344101,GE61VT2900000006198351,9817727,GE91VT2900000037113651,16038106,9153517,16721033,11354160,9433569,10851367,10135158,GE74VT2900000010534405,12959303,9863743,9816769,GE40VT2900001883544101,GE96VT2900001183212405,GE08VT2900000144744405,GE24VT2900000017981801,10135156,GE49VT2900000078693651,16789607,11564517,11564518,GE44VT2900001088461801,9529630,12230078,9455212,GE77VT2900001465862405,9433568,GE83VT1000001311484506,GE64VT2900000098821851,GE45VT2900000051613651,GE83VT2900000050853651,9153516,GE48VT2900000099083651,8936786,11400288,GE84VT2900000004768351,GE77VT2900001288194101,GE16VT2900000004113661,10376857,11564516,10135157,9475060,16789609,9403388,10376856,GE35VT2900000055352405,GE81VT2900000112061851,13995407,GE77VT2900000136574405,GE35VT2900001359271801,16724456,GE19VT2900000019648351,16045208,GE34VT2900000002604405,GE66VT2900000000753651,10090796,GE17VT2900000134864405,GE06VT2900000047068351,GE12VT2900000009118351,16093865,GE77VT2900000244632405,GE42VT2900000066223651,GE89VT2900001000361905,16092516,9851451,9462929,11330530,GE87VT2900001453052405,11400304,8936785,GE95VT2900000000834415,12230057,GE20VT2900000118314405,GE23VT2900000037028351,GE19VT2900000075311801,GE55VT2900000002184405,GE09VT2900000099863651,GE64VT2900000112972405,8936787,GE67VT2900000208942405,GE42VT2900000064283651,11871863,GE28VT2900000134644405,GE72VT2900000121384101,10074353,9455466,10074354,12094155,GE09VT2900000029053651,GE42VT2900000121411801,GE30VT2900000110354405,16666018,10825848,11354161,16194136,GE75VT1000001168084506,GE46VT2900000147864405,10608208,14230993,9403387,GE86VT2900000062491851,GE49VT2900000976572405,GE52VT2900000016078351,10074355,9153482,GE27VT2900000029188351,GE44VT2900001876674101,GE02VT2900000030163651,GE57VT2900000005474415,16114824,16826398,10090794,GE52VT2900000117674405,11436003,GE47VT2900000009863651,GE24VT2900000002088351,16629004,GE56VT2900000002418351,16114823,12094156,GE26VT2900001862484101,12094157,GE30VT2900000061114101,GE87VT2900000053924405,GE66VT2900000218504101,GE38VT2900000199664101,12230077}'::text[])))
  • Filter: ((("Movement".document ->> 'valueDate'::text) >= '2020-08-16'::text) AND (("Movement".document ->> 'valueDate'::text) <= '2020-09-15'::text) AND ((((("Movement".document -> 'movementType'::text) ->> 'entityUniqueId'::text) = ANY ('{TCDepositOperation,TCPaymentByCard,TCLoanOperation,TCSMSCashout,TCOther,TCBillPayment,TCATMCashout,TCFee,TCTreasury,TCCurrencyExchange,TCOtherAccountOutgoing,TCOwnAccount}'::text[])) AND ((("Movement".document ->> 'directionDRCR'::text))::numeric = '1'::numeric)) OR (((("Movement".document -> 'movementType'::text) ->> 'entityUniqueId'::text) = 'TCCashOperation'::text) AND ((("Movement".document ->> 'altaCreditCustomer'::text))::numeric <> '993639'::numeric) AND ((("Movement".document ->> 'directionDRCR'::text))::numeric = '1'::numeric)) OR (((("Movement".document -> 'movementType'::text) ->> 'entityUniqueId'::text) = 'TCCashOperation'::text) AND ((("Movement".document ->> 'altaCreditCustomer'::text))::numeric IS NULL) AND ((("Movement".document ->> 'directionDRCR'::text))::numeric = '1'::numeric)) OR (((("Movement".document -> 'movementType'::text) ->> 'entityUniqueId'::text) = 'TCFastMoneyTransfer'::text) AND ((("Movement".document ->> 'altaCreditCustomer'::text))::numeric = '993639'::numeric) AND ((("Movement".document ->> 'directionDRCR'::text))::numeric = '1'::numeric)) OR (((("Movement".document -> 'movementType'::text) ->> 'entityUniqueId'::text) = ANY ('{TCDepositOperation,TCPaymentByCard,TCCashOperation,TCFastMoneyTransfer,TCLoanOperation,TCSMSCashout,TCOther}'::text[])) AND ((("Movement".document ->> 'directionDRCR'::text))::numeric = '0'::numeric)) OR (((("Movement".document -> 'movementType'::text) ->> 'entityUniqueId'::text) = ANY ('{TCDepositOperation,TCPaymentByCard,TCCashOperation,TCFastMoneyTransfer,TCLoanOperation,TCSMSCashout,TCOther}'::text[])) AND ((("Movement".document ->> 'directionDRCR'::text))::numeric = '0'::numeric)) OR (((("Movement".document -> 'movementType'::text) ->> 'entityUniqueId'::text) = 'TCOtherAccountIncoming'::text) AND ((("Movement".document ->> 'directionDRCR'::text))::numeric = '0'::numeric))))
  • Rows Removed by Filter: 2,121
  • Buffers: shared hit=2,801
17. 1.176 1.176 ↑ 1.0 1 84

Index Scan using accounts_pkey on gds.accounts "Movement_clientAccount" (cost=0.44..2.67 rows=1 width=1,508) (actual time=0.014..0.014 rows=1 loops=84)

  • Output: "Movement_clientAccount".entityuniqueid, "Movement_clientAccount".sequenceno, "Movement_clientAccount".document
  • Index Cond: (("Movement_clientAccount".entityuniqueid)::text = (("Movement".document -> 'clientAccount'::text) ->> 'entityUniqueId'::text))
  • Filter: ((("Movement_clientAccount".document -> 'accountType'::text) ->> 'entityUniqueId'::text) = ANY ('{32,100,101,200}'::text[]))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=336
18. 0.078 0.225 ↓ 12.0 12 75

Materialize (cost=0.00..4.98 rows=1 width=781) (actual time=0.001..0.003 rows=12 loops=75)

  • Output: "Movement_clientAccount_accountType".document, "Movement_clientAccount_accountType".entityuniqueid, "Movement_clientAccount_accountType_defaultAccountIcon".document
  • Buffers: shared hit=15
19. 0.061 0.147 ↓ 12.0 12 1

Nested Loop Left Join (cost=0.00..4.98 rows=1 width=781) (actual time=0.044..0.147 rows=12 loops=1)

  • Output: "Movement_clientAccount_accountType".document, "Movement_clientAccount_accountType".entityuniqueid, "Movement_clientAccount_accountType_defaultAccountIcon".document
  • Inner Unique: true
  • Join Filter: ((("Movement_clientAccount_accountType".document -> 'defaultAccountIcon'::text) ->> 'entityUniqueId'::text) = ("Movement_clientAccount_accountType_defaultAccountIcon".entityuniqueid)::text)
  • Rows Removed by Join Filter: 202
  • Buffers: shared hit=15
20. 0.026 0.026 ↓ 12.0 12 1

Seq Scan on gds.accounttypes "Movement_clientAccount_accountType" (cost=0.00..1.18 rows=1 width=483) (actual time=0.020..0.026 rows=12 loops=1)

  • Output: "Movement_clientAccount_accountType".entityuniqueid, "Movement_clientAccount_accountType".sequenceno, "Movement_clientAccount_accountType".document
  • Filter: (("Movement_clientAccount_accountType".document ->> 'entityType'::text) = 'AccountType'::text)
  • Buffers: shared hit=1
21. 0.060 0.060 ↓ 18.0 18 12

Seq Scan on gds.producticons "Movement_clientAccount_accountType_defaultAccountIcon" (cost=0.00..3.78 rows=1 width=310) (actual time=0.001..0.005 rows=18 loops=12)

  • Output: "Movement_clientAccount_accountType_defaultAccountIcon".entityuniqueid, "Movement_clientAccount_accountType_defaultAccountIcon".sequenceno, "Movement_clientAccount_accountType_defaultAccountIcon".document
  • Filter: (("Movement_clientAccount_accountType_defaultAccountIcon".document ->> 'entityType'::text) = 'ProductIcon'::text)
  • Buffers: shared hit=14
22. 0.054 0.075 ↓ 8.0 8 75

Materialize (cost=0.00..1.23 rows=1 width=483) (actual time=0.000..0.001 rows=8 loops=75)

  • Output: "Movement_movementType".document, "Movement_movementType".entityuniqueid
  • Buffers: shared hit=1
23. 0.021 0.021 ↓ 15.0 15 1

Seq Scan on gds.accountmovementtypes "Movement_movementType" (cost=0.00..1.23 rows=1 width=483) (actual time=0.013..0.021 rows=15 loops=1)

  • Output: "Movement_movementType".document, "Movement_movementType".entityuniqueid
  • Filter: (("Movement_movementType".document ->> 'entityType'::text) = 'AccountMovementType'::text)
  • Buffers: shared hit=1
24. 0.118 0.150 ↓ 20.0 20 75

Materialize (cost=0.00..5.79 rows=1 width=667) (actual time=0.000..0.002 rows=20 loops=75)

  • Output: "Movement_currency".document, "Movement_currency".entityuniqueid
  • Buffers: shared hit=2
25. 0.032 0.032 ↓ 20.0 20 1

Seq Scan on gds.currencies "Movement_currency" (cost=0.00..5.78 rows=1 width=667) (actual time=0.011..0.032 rows=20 loops=1)

  • Output: "Movement_currency".document, "Movement_currency".entityuniqueid
  • Filter: (("Movement_currency".document ->> 'entityType'::text) = 'Currency'::text)
  • Buffers: shared hit=2
26. 0.325 0.375 ↓ 52.0 52 75

Materialize (cost=0.00..5.79 rows=1 width=667) (actual time=0.000..0.005 rows=52 loops=75)

  • Output: "Movement_partnerCurrency".document, "Movement_partnerCurrency".entityuniqueid
  • Buffers: shared hit=5
27. 0.050 0.050 ↓ 52.0 52 1

Seq Scan on gds.currencies "Movement_partnerCurrency" (cost=0.00..5.78 rows=1 width=667) (actual time=0.008..0.050 rows=52 loops=1)

  • Output: "Movement_partnerCurrency".document, "Movement_partnerCurrency".entityuniqueid
  • Filter: (("Movement_partnerCurrency".document ->> 'entityType'::text) = 'Currency'::text)
  • Buffers: shared hit=5
28. 0.267 0.300 ↓ 52.0 52 75

Materialize (cost=0.00..3.79 rows=1 width=310) (actual time=0.000..0.004 rows=52 loops=75)

  • Output: "Movement_clientAccount_customProductIcon".document, "Movement_clientAccount_customProductIcon".entityuniqueid
  • Buffers: shared hit=3
29. 0.033 0.033 ↓ 52.0 52 1

Seq Scan on gds.producticons "Movement_clientAccount_customProductIcon" (cost=0.00..3.78 rows=1 width=310) (actual time=0.006..0.033 rows=52 loops=1)

  • Output: "Movement_clientAccount_customProductIcon".document, "Movement_clientAccount_customProductIcon".entityuniqueid
  • Filter: (("Movement_clientAccount_customProductIcon".document ->> 'entityType'::text) = 'ProductIcon'::text)
  • Buffers: shared hit=3
30. 1.650 1.650 ↓ 0.0 0 75

Index Scan using accounts_pkey on gds.accounts "Movement_partnerClientAccount" (cost=0.44..2.66 rows=1 width=1,508) (actual time=0.022..0.022 rows=0 loops=75)

  • Output: "Movement_partnerClientAccount".entityuniqueid, "Movement_partnerClientAccount".sequenceno, "Movement_partnerClientAccount".document
  • Index Cond: ((("Movement".document -> 'partnerClientAccount'::text) ->> 'entityUniqueId'::text) = ("Movement_partnerClientAccount".entityuniqueid)::text)
  • Buffers: shared hit=244
31. 0.081 0.210 ↓ 12.0 12 70

Materialize (cost=0.00..4.98 rows=1 width=781) (actual time=0.001..0.003 rows=12 loops=70)

  • Output: "Movement_partnerClientAccount_accountType".document, "Movement_partnerClientAccount_accountType".entityuniqueid, "Movement_partnerClientAccount_accountType_defaultAccountIcon".document
  • Buffers: shared hit=15
32. 0.064 0.129 ↓ 12.0 12 1

Nested Loop Left Join (cost=0.00..4.98 rows=1 width=781) (actual time=0.030..0.129 rows=12 loops=1)

  • Output: "Movement_partnerClientAccount_accountType".document, "Movement_partnerClientAccount_accountType".entityuniqueid, "Movement_partnerClientAccount_accountType_defaultAccountIcon".document
  • Inner Unique: true
  • Join Filter: ((("Movement_partnerClientAccount_accountType".document -> 'defaultAccountIcon'::text) ->> 'entityUniqueId'::text) = ("Movement_partnerClientAccount_accountType_defaultAccountIcon".entityuniqueid)::text)
  • Rows Removed by Join Filter: 202
  • Buffers: shared hit=15
33. 0.017 0.017 ↓ 12.0 12 1

Seq Scan on gds.accounttypes "Movement_partnerClientAccount_accountType" (cost=0.00..1.18 rows=1 width=483) (actual time=0.012..0.017 rows=12 loops=1)

  • Output: "Movement_partnerClientAccount_accountType".entityuniqueid, "Movement_partnerClientAccount_accountType".sequenceno, "Movement_partnerClientAccount_accountType".document
  • Filter: (("Movement_partnerClientAccount_accountType".document ->> 'entityType'::text) = 'AccountType'::text)
  • Buffers: shared hit=1
34. 0.048 0.048 ↓ 18.0 18 12

Seq Scan on gds.producticons "Movement_partnerClientAccount_accountType_defaultAccountIcon" (cost=0.00..3.78 rows=1 width=310) (actual time=0.001..0.004 rows=18 loops=12)

  • Output: "Movement_partnerClientAccount_accountType_defaultAccountIcon".entityuniqueid, "Movement_partnerClientAccount_accountType_defaultAccountIcon".sequenceno, "Movement_partnerClientAccount_accountType_defaultAccountIcon".document
  • Filter: (("Movement_partnerClientAccount_accountType_defaultAccountIcon".document ->> 'entityType'::text) = 'ProductIcon'::text)
  • Buffers: shared hit=14
35. 0.264 0.280 ↓ 52.0 52 70

Materialize (cost=0.00..3.79 rows=1 width=310) (actual time=0.000..0.004 rows=52 loops=70)

  • Output: "Movement_partnerClientAccount_customProductIcon".document, "Movement_partnerClientAccount_customProductIcon".entityuniqueid
  • Buffers: shared hit=3
36. 0.016 0.016 ↓ 52.0 52 1

Seq Scan on gds.producticons "Movement_partnerClientAccount_customProductIcon" (cost=0.00..3.78 rows=1 width=310) (actual time=0.003..0.016 rows=52 loops=1)

  • Output: "Movement_partnerClientAccount_customProductIcon".document, "Movement_partnerClientAccount_customProductIcon".entityuniqueid
  • Filter: (("Movement_partnerClientAccount_customProductIcon".document ->> 'entityType'::text) = 'ProductIcon'::text)
  • Buffers: shared hit=3
37. 0.280 0.280 ↓ 0.0 0 70

Index Scan using bptransactions_pkey on gds.bptransactions "Movement_bpTransaction" (cost=0.29..2.42 rows=1 width=775) (actual time=0.004..0.004 rows=0 loops=70)

  • Output: "Movement_bpTransaction".entityuniqueid, "Movement_bpTransaction".sequenceno, "Movement_bpTransaction".document
  • Index Cond: ((("Movement".document -> 'bpTransaction'::text) ->> 'entityUniqueId'::text) = ("Movement_bpTransaction".entityuniqueid)::text)
  • Filter: (("Movement_bpTransaction".document ->> 'entityType'::text) = 'BPTransaction'::text)
  • Buffers: shared hit=32
38. 0.719 0.840 ↓ 170.0 170 70

Materialize (cost=0.00..12.57 rows=1 width=421) (actual time=0.000..0.012 rows=170 loops=70)

  • Output: "Movement_bpTransaction_providerCode".document, "Movement_bpTransaction_providerCode".entityuniqueid
  • Buffers: shared hit=10
39. 0.121 0.121 ↓ 171.0 171 1

Seq Scan on gds.bpproviders "Movement_bpTransaction_providerCode" (cost=0.00..12.56 rows=1 width=421) (actual time=0.010..0.121 rows=171 loops=1)

  • Output: "Movement_bpTransaction_providerCode".document, "Movement_bpTransaction_providerCode".entityuniqueid
  • Filter: (("Movement_bpTransaction_providerCode".document ->> 'entityType'::text) = 'BPProvider'::text)
  • Buffers: shared hit=10
40. 2.106 2.730 ↓ 173.5 347 70

Materialize (cost=0.00..63.52 rows=2 width=1,143) (actual time=0.000..0.039 rows=347 loops=70)

  • Output: "Movement_bpTransaction_serviceCode".document, "Movement_bpTransaction_serviceCode".entityuniqueid
  • Buffers: shared hit=58
41. 0.624 0.624 ↓ 183.5 367 1

Seq Scan on gds.bpservices "Movement_bpTransaction_serviceCode" (cost=0.00..63.51 rows=2 width=1,143) (actual time=0.014..0.624 rows=367 loops=1)

  • Output: "Movement_bpTransaction_serviceCode".document, "Movement_bpTransaction_serviceCode".entityuniqueid
  • Filter: (("Movement_bpTransaction_serviceCode".document ->> 'entityType'::text) = 'BPService'::text)
  • Buffers: shared hit=58
42. 0.053 0.070 ↓ 5.0 5 70

Materialize (cost=0.00..1.08 rows=1 width=197) (actual time=0.000..0.001 rows=5 loops=70)

  • Output: "Movement_bpTransaction_serviceCode_billType".document, "Movement_bpTransaction_serviceCode_billType".entityuniqueid
  • Buffers: shared hit=1
43. 0.017 0.017 ↓ 5.0 5 1

Seq Scan on gds.bpbilltypes "Movement_bpTransaction_serviceCode_billType" (cost=0.00..1.07 rows=1 width=197) (actual time=0.012..0.017 rows=5 loops=1)

  • Output: "Movement_bpTransaction_serviceCode_billType".document, "Movement_bpTransaction_serviceCode_billType".entityuniqueid
  • Filter: (("Movement_bpTransaction_serviceCode_billType".document ->> 'entityType'::text) = 'BPBillType'::text)
  • Buffers: shared hit=1
Planning time : 34.463 ms
Execution time : 94.124 ms