explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Tgvt

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.210 ↓ 0.0 0 1

Limit (cost=2,288.11..2,288.11 rows=2 width=388) (actual time=0.210..0.210 rows=0 loops=1)

2. 0.038 0.209 ↓ 0.0 0 1

Sort (cost=2,288.11..2,288.11 rows=2 width=388) (actual time=0.209..0.209 rows=0 loops=1)

  • Sort Key: tb_dist_operation_application.id_dist_operation_application DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.001 0.171 ↓ 0.0 0 1

Append (cost=0.15..2,288.11 rows=2 width=388) (actual time=0.171..0.171 rows=0 loops=1)

4. 0.000 0.141 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.15..2,166.54 rows=1 width=387) (actual time=0.141..0.141 rows=0 loops=1)

  • Join Filter: ((tb_dist_fund_dac.id_contract = tb_dist_fund_selected.id_contract) AND (tb_dist_fund_dac.id_dac = tb_dist_fund_selected.id_dac))
5. 0.000 0.141 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.15..2,166.32 rows=1 width=273) (actual time=0.141..0.141 rows=0 loops=1)

  • Join Filter: ((dm_tp_requestor.id_contract = tb_dist_operation_application.id_contract) AND ((dm_tp_requestor.tp_requestor)::text = (tb_dist_operation_application_log.tp_requestor)::text))
6. 0.000 0.141 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.15..2,166.11 rows=1 width=252) (actual time=0.141..0.141 rows=0 loops=1)

  • Join Filter: ((tb_dist_operation_application_log.id_contract = tb_dist_operation_application.id_contract) AND (tb_dist_operation_application_log.id_dist_operation_application = tb_dist_operation_application.id_dist_operation_application))
7. 0.000 0.141 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.15..32.84 rows=1 width=242) (actual time=0.141..0.141 rows=0 loops=1)

  • Join Filter: (dm_dist_operation_status.id_status_order = tb_dist_operation_application.id_status_order)
8. 0.000 0.141 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.15..32.61 rows=1 width=224) (actual time=0.141..0.141 rows=0 loops=1)

  • Join Filter: ((dm_dist_operation_type.cd_operation_type)::text = (tb_dist_operation_application.cd_operation_type)::text)
9. 0.000 0.141 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.15..32.38 rows=1 width=164) (actual time=0.141..0.141 rows=0 loops=1)

10. 0.001 0.141 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.11..1.72 rows=1 width=168) (actual time=0.141..0.141 rows=0 loops=1)

11. 0.000 0.140 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.10..1.31 rows=1 width=115) (actual time=0.140..0.140 rows=0 loops=1)

12. 0.001 0.140 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.06..0.86 rows=1 width=78) (actual time=0.140..0.140 rows=0 loops=1)

13. 0.139 0.139 ↓ 0.0 0 1

Index Scan using tb_dist_operation_application_para_oms on tb_dist_operation_application (cost=0.03..0.43 rows=1 width=77) (actual time=0.139..0.139 rows=0 loops=1)

  • Index Cond: ((id_contract = 39) AND (id_status_order = 17))
14. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_dist_customer_account_pk on tb_dist_customer_account (cost=0.03..0.43 rows=1 width=25) (never executed)

  • Index Cond: ((id_contract = tb_dist_operation_application.id_contract) AND (id_contract = 39) AND (id_customer = tb_dist_operation_application.id_customer) AND (id_manager = tb_dist_operation_application.id_manager) AND (cd_account_sinacor = tb_dist_operation_application.cd_account))
15. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_core_customer_data_pk on tb_core_customer_data (cost=0.04..0.44 rows=1 width=45) (never executed)

  • Index Cond: ((tb_dist_operation_application.id_contract = id_contract) AND (id_contract = 39) AND (id_customer = tb_dist_operation_application.id_customer))
16. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_dist_fund_selected_pk on tb_dist_fund_selected (cost=0.01..0.42 rows=1 width=53) (never executed)

  • Index Cond: ((id_contract = tb_dist_operation_application.id_contract) AND (id_contract = 39) AND (id_instrument = tb_dist_operation_application.id_instrument))
17. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_dist_certificate_idx1 on tb_dist_certificate (cost=0.04..30.65 rows=1 width=12) (never executed)

  • Index Cond: ((id_contract = tb_dist_operation_application.id_contract) AND (id_contract = 39) AND (id_instrument = tb_dist_operation_application.id_instrument))
  • Filter: (id_dist_operation_application = tb_dist_operation_application.id_dist_operation_application)
18. 0.000 0.000 ↓ 0.0 0

Seq Scan on dm_dist_operation_type (cost=0.00..0.21 rows=13 width=71) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Seq Scan on dm_dist_operation_status (cost=0.00..0.23 rows=1 width=22) (never executed)

  • Filter: (id_status_order = 17)
20. 0.000 0.000 ↓ 0.0 0

Seq Scan on tb_dist_operation_application_log (cost=0.00..2,101.82 rows=20,971 width=18) (never executed)

  • Filter: ((id_contract = 39) AND ((action)::text = 'INSERT'::text))
21. 0.000 0.000 ↓ 0.0 0

Seq Scan on dm_tp_requestor (cost=0.00..0.21 rows=4 width=48) (never executed)

  • Filter: (id_contract = 39)
22. 0.000 0.000 ↓ 0.0 0

Seq Scan on tb_dist_fund_dac (cost=0.00..0.21 rows=4 width=18) (never executed)

  • Filter: (id_contract = 39)
23. 0.000 0.029 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.16..121.57 rows=1 width=389) (actual time=0.029..0.029 rows=0 loops=1)

24. 0.000 0.029 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.13..121.14 rows=1 width=281) (actual time=0.029..0.029 rows=0 loops=1)

  • Join Filter: ((dm_tp_requestor_1.id_contract = tb_dist_operation_withdraw_log.id_contract) AND ((dm_tp_requestor_1.tp_requestor)::text = (tb_dist_operation_withdraw_log.tp_requestor)::text))
25. 0.000 0.029 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.13..120.93 rows=1 width=260) (actual time=0.029..0.029 rows=0 loops=1)

  • Join Filter: ((tb_dist_fund_dac_1.id_contract = tb_dist_fund_selected_1.id_contract) AND (tb_dist_fund_dac_1.id_dac = tb_dist_fund_selected_1.id_dac))
26. 0.000 0.029 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.13..120.72 rows=1 width=258) (actual time=0.029..0.029 rows=0 loops=1)

27. 0.001 0.029 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.10..2.59 rows=1 width=244) (actual time=0.029..0.029 rows=0 loops=1)

28. 0.000 0.028 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.06..2.14 rows=1 width=203) (actual time=0.028..0.028 rows=0 loops=1)

29. 0.000 0.028 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.04..1.30 rows=1 width=203) (actual time=0.028..0.028 rows=0 loops=1)

  • Join Filter: (dm_dist_operation_status_1.id_status_order = tb_dist_operation_withdraw.id_status_order)
30. 0.000 0.028 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.04..1.08 rows=1 width=185) (actual time=0.028..0.028 rows=0 loops=1)

  • Join Filter: ((dm_dist_operation_type_1.cd_operation_type)::text = (tb_dist_operation_withdraw.cd_operation_type)::text)
31. 0.000 0.028 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.04..0.85 rows=1 width=125) (actual time=0.028..0.028 rows=0 loops=1)

32. 0.028 0.028 ↓ 0.0 0 1

Index Scan using tb_dist_operation_withdraw_id_contract_id_status_order_idx on tb_dist_operation_withdraw (cost=0.03..0.43 rows=1 width=76) (actual time=0.028..0.028 rows=0 loops=1)

  • Index Cond: ((id_contract = 39) AND (id_status_order = 17))
33. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_dist_fund_selected_pk on tb_dist_fund_selected tb_dist_fund_selected_1 (cost=0.01..0.42 rows=1 width=53) (never executed)

  • Index Cond: ((tb_dist_operation_withdraw.id_contract = id_contract) AND (id_contract = 39) AND (id_instrument = tb_dist_operation_withdraw.id_instrument))
34. 0.000 0.000 ↓ 0.0 0

Seq Scan on dm_dist_operation_type dm_dist_operation_type_1 (cost=0.00..0.21 rows=13 width=71) (never executed)

35. 0.000 0.000 ↓ 0.0 0

Seq Scan on dm_dist_operation_status dm_dist_operation_status_1 (cost=0.00..0.23 rows=1 width=22) (never executed)

  • Filter: (id_status_order = 17)
36. 0.000 0.000 ↓ 0.0 0

Index Only Scan using tb_dist_operation_withdraw_request_pk on tb_dist_operation_withdraw_request (cost=0.01..0.84 rows=1 width=8) (never executed)

  • Index Cond: ((id_contract = tb_dist_operation_withdraw.id_contract) AND (id_contract = 39) AND (id_dist_operation_withdraw = tb_dist_operation_withdraw.id_dist_operation_withdraw))
  • Filter: (seq = (SubPlan 2))
  • Heap Fetches: 0
37.          

SubPlan (for Index Only Scan)

38. 0.000 0.000 ↓ 0.0 0

Result (cost=0.42..0.42 rows=1 width=4) (never executed)

39.          

Initplan (for Result)

40. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.01..0.42 rows=1 width=4) (never executed)

41. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using tb_dist_operation_withdraw_request_pk on tb_dist_operation_withdraw_request inner_request (cost=0.01..0.42 rows=1 width=4) (never executed)

  • Index Cond: ((id_contract = tb_dist_operation_withdraw_request.id_contract) AND (id_dist_operation_withdraw = tb_dist_operation_withdraw_request.id_dist_operation_withdraw) AND (seq IS NOT NULL))
  • Filter: ((cd_status)::text <> 'PENDENT'::text)
42. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_core_customer_data_pk on tb_core_customer_data tb_core_customer_data_1 (cost=0.04..0.44 rows=1 width=45) (never executed)

  • Index Cond: ((tb_dist_operation_withdraw.id_contract = id_contract) AND (id_contract = 39) AND (id_customer = tb_dist_operation_withdraw.id_customer))
43. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_dist_operation_withdraw_log_search_idx on tb_dist_operation_withdraw_log (cost=0.03..118.13 rows=1 width=18) (never executed)

  • Index Cond: ((id_contract = tb_dist_operation_withdraw.id_contract) AND (id_contract = 39) AND ((action)::text = 'INSERT'::text))
  • Filter: (id_dist_operation_withdraw = tb_dist_operation_withdraw.id_dist_operation_withdraw)
44. 0.000 0.000 ↓ 0.0 0

Seq Scan on tb_dist_fund_dac tb_dist_fund_dac_1 (cost=0.00..0.21 rows=4 width=18) (never executed)

  • Filter: (id_contract = 39)
45. 0.000 0.000 ↓ 0.0 0

Seq Scan on dm_tp_requestor dm_tp_requestor_1 (cost=0.00..0.21 rows=4 width=48) (never executed)

  • Filter: (id_contract = 39)
46. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_dist_customer_account_pk on tb_dist_customer_account tb_dist_customer_account_1 (cost=0.03..0.43 rows=1 width=25) (never executed)

  • Index Cond: ((id_contract = tb_dist_operation_withdraw.id_contract) AND (id_contract = 39) AND (id_customer = tb_dist_operation_withdraw.id_customer) AND (id_manager = tb_dist_operation_withdraw.id_manager) AND (cd_account_sinacor = tb_dist_operation_withdraw.cd_account))
Planning time : 11.828 ms
Execution time : 0.918 ms