explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QEYs

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1.555 ↑ 1.0 10 1

Limit (cost=354.69..354.71 rows=10 width=380) (actual time=1.545..1.555 rows=10 loops=1)

  • 39) AND (id_customer = tb_dist_operation_application.id_customer))
2. 0.098 1.552 ↑ 2.7 10 1

Sort (cost=354.69..354.76 rows=27 width=380) (actual time=1.544..1.552 rows=10 loops=1)

  • Sort Key: tb_dist_operation_application.id_dist_operation_application DESC
  • Sort Method: top-N heapsort Memory: 30kB
3. 0.005 1.454 ↑ 1.2 23 1

Append (cost=44.42..354.11 rows=27 width=380) (actual time=0.930..1.454 rows=23 loops=1)

4. 0.206 1.449 ↑ 1.2 23 1

Nested Loop Left Join (cost=44.42..353.84 rows=27 width=380) (actual time=0.930..1.449 rows=23 loops=1)

  • Join Filter: ((tb_dist_operation_application_pendencies.id_contract = tb_dist_operation_application.id_contract) AND (tb_dist_operation_application_pendencies.id_dist_operation_application = tb_dist_operation_application.id_dist_operation_application) AND (tb_dist_operation_application_pendencies.id_pendency = tb_dist_operation_application.id_pendency))
  • Rows Removed by Join Filter: 230
5. 0.060 1.243 ↑ 1.2 23 1

Nested Loop Left Join (cost=44.42..331.46 rows=27 width=244) (actual time=0.886..1.243 rows=23 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))
  • Rows Removed by Join Filter: 69
6. 0.036 1.183 ↑ 1.2 23 1

Nested Loop Left Join (cost=44.42..329.94 rows=27 width=216) (actual time=0.869..1.183 rows=23 loops=1)

  • Join Filter: (dm_dist_operation_status.id_status_order = tb_dist_operation_application.id_status_order)
7. 0.081 1.147 ↑ 1.2 23 1

Hash Left Join (cost=44.42..328.28 rows=27 width=184) (actual time=0.851..1.147 rows=23 loops=1)

  • Hash Cond: ((tb_dist_operation_application.cd_operation_type)::text = (dm_dist_operation_type.cd_operation_type)::text)
8. 0.394 1.066 ↑ 1.2 23 1

Hash Left Join (cost=43.13..326.62 rows=27 width=152) (actual time=0.790..1.066 rows=23 loops=1)

  • Hash Cond: ((tb_dist_operation_application.id_contract = tb_dist_fund_selected.id_contract) AND (tb_dist_operation_application.id_instrument = tb_dist_fund_selected.id_instrument))
9. 0.203 0.672 ↑ 1.2 23 1

Nested Loop Left Join (cost=19.40..302.41 rows=27 width=102) (actual time=0.412..0.672 rows=23 loops=1)

  • -> Index Scan using tb_core_customer_data_pk on tb_core_customer_data (cost=0.42..8.44 rows=1
10. 0.050 0.469 ↑ 1.2 23 1

Hash Left Join (cost=18.98..74.13 rows=27 width=72) (actual time=0.391..0.469 rows=23 loops=1)

  • Hash Cond: ((tb_dist_operation_application.id_contract = tb_dist_customer_account.id_contract) AND (tb_dist_operation_application.id_manager = tb_dist_customer_account.id_manager) AND (tb_dist_operation_application.id_customer = tb_dist_customer_account.id_customer) AND (tb_dist_operation_application.cd_account = tb_dist_customer_account.cd_account_sinacor))
11. 0.080 0.080 ↑ 1.2 23 1

Index Scan using tb_dist_operation_application_para_oms on tb_dist_operation_application (cost=0.29..54.89 rows=27 width=67) (actual time=0.025..0.080 rows=23 loops=1)

  • Index Cond: ((id_contract = 39) AND (id_status_order = 25))
12. 0.181 0.339 ↓ 1.0 453 1

Hash (cost=9.65..9.65 rows=452 width=25) (actual time=0.339..0.339 rows=453 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 37kB
13. 0.158 0.158 ↓ 1.0 453 1

Seq Scan on tb_dist_customer_account (cost=0.00..9.65 rows=452 width=25) (actual time=0.017..0.158 rows=453 loops=1)

  • Filter: (id_contract = 39)
14. 0.000 0.184 ↓ 0.0 1 23

width=38) (cost=0..0 rows=0 width=0) (actual time=0.007..0.008 rows=1 loops=23)

  • Index Cond: ((tb_dist_operation_application.id_contract = id_contract) AND (id_contract =
15. 0.099 0.356 ↑ 1.0 172 1

Hash (cost=21.15..21.15 rows=172 width=54) (actual time=0.356..0.356 rows=172 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 23kB
16. 0.257 0.257 ↑ 1.0 172 1

Seq Scan on tb_dist_fund_selected (cost=0.00..21.15 rows=172 width=54) (actual time=0.011..0.257 rows=172 loops=1)

  • Filter: (id_contract = 39)
17. 0.034 0.034 ↑ 1.0 13 1

Hash (cost=1.13..1.13 rows=13 width=64) (actual time=0.034..0.034 rows=13 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • -> Seq Scan on dm_dist_operation_type (cost=0.00..1.13 rows=13 width=64) (actual time=0.008..0.011rows=13 loops=1)
18. 0.012 0.023 ↑ 1.0 1 23

Materialize (cost=0.00..1.25 rows=1 width=36) (actual time=0.001..0.001 rows=1 loops=23)

19. 0.011 0.011 ↑ 1.0 1 1

Seq Scan on dm_dist_operation_status (cost=0.00..1.25 rows=1 width=36) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (id_status_order = 25)
  • Rows Removed by Filter: 25
20. 0.012 0.023 ↓ 4.0 4 23

Materialize (cost=0.00..1.05 rows=1 width=44) (actual time=0.001..0.001 rows=4 loops=23)

21. 0.011 0.011 ↓ 4.0 4 1

Seq Scan on tb_dist_fund_dac (cost=0.00..1.05 rows=1 width=44) (actual time=0.009..0.011 rows=4 loops=1)

  • Filter: (id_contract = 39)
22. 0.046 0.046 ↓ 2.5 10 23

Materialize (cost=0.00..20.02 rows=4 width=42) (actual time=0.001..0.002 rows=10 loops=23)

  • -> Seq Scan on tb_dist_operation_application_pendencies (cost=0.00..20.00 rows=4 width=42) (actual time=0.006..0.009rows=10 loops=1)
  • Filter: (id_contract = 39)
Planning time : 12.397 ms
Execution time : 2.002 ms