explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Eg3oL

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 193.371 ↑ 1.0 1 1

Group (cost=14,372.41..14,372.93 rows=1 width=144) (actual time=193.370..193.371 rows=1 loops=1)

  • Group Key: obpos_app_0_.fin_financial_account_id, obpos_app_0_.name, obpos_app_0_.value, (c_currency_rate(fin_financ1_.c_currency_id, organizati4_.c_currency_id, NULL::timestamp without time zone, NULL::chara
  • Buffers: shared hit=9726
2. 0.034 193.368 ↑ 1.0 1 1

Sort (cost=14,372.41..14,372.42 rows=1 width=144) (actual time=193.368..193.368 rows=1 loops=1)

  • Sort Key: obpos_app_0_.fin_financial_account_id, obpos_app_0_.name, obpos_app_0_.value, (c_currency_rate(fin_financ1_.c_currency_id, organizati4_.c_currency_id, NULL::timestamp without time zone, NULL::
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=9726
3. 9.209 193.334 ↑ 1.0 1 1

Hash Semi Join (cost=9,374.16..14,372.40 rows=1 width=144) (actual time=71.661..193.334 rows=1 loops=1)

  • Hash Cond: ((obpos_app_0_.fin_financial_account_id)::text = (fin_paymen20_.em_obdico_fin_account_id)::text)
  • Buffers: shared hit=9717
4. 16.785 183.949 ↓ 1.0 61,444 1

Hash Join (cost=9,356.04..14,192.50 rows=61,437 width=187) (actual time=69.511..183.949 rows=61,444 loops=1)

  • Hash Cond: ((obpos_app_0_.obpos_app_payment_type_id)::text = (obpos_app_17_.obpos_app_payment_type_id)::text)
  • Buffers: shared hit=9583
5. 14.180 153.477 ↓ 1.0 61,444 1

Hash Join (cost=7,750.12..12,425.26 rows=61,437 width=218) (actual time=55.673..153.477 rows=61,444 loops=1)

  • Hash Cond: ((organizati4_.c_currency_id)::text = (currency5_.c_currency_id)::text)
  • Buffers: shared hit=8352
6. 14.540 139.240 ↓ 1.0 61,444 1

Hash Join (cost=7,743.19..12,254.81 rows=61,437 width=218) (actual time=55.597..139.240 rows=61,444 loops=1)

  • Hash Cond: ((obpos_appl3_.ad_org_id)::text = (organizati4_.ad_org_id)::text)
  • Buffers: shared hit=8349
7. 16.892 124.356 ↓ 1.0 61,444 1

Hash Join (cost=7,661.75..12,010.95 rows=61,437 width=214) (actual time=55.239..124.356 rows=61,444 loops=1)

  • Hash Cond: ((obpos_app_0_.obpos_applications_id)::text = (obpos_appl3_.obpos_applications_id)::text)
  • Buffers: shared hit=8281
8. 14.146 103.334 ↓ 1.0 61,444 1

Hash Join (cost=7,098.34..11,286.17 rows=61,437 width=181) (actual time=51.065..103.334 rows=61,444 loops=1)

  • Hash Cond: ((fin_financ1_.c_currency_id)::text = (currency2_.c_currency_id)::text)
  • Buffers: shared hit=7868
9. 28.253 89.130 ↓ 1.0 61,444 1

Hash Join (cost=7,091.40..11,114.06 rows=61,437 width=177) (actual time=50.980..89.130 rows=61,444 loops=1)

  • Hash Cond: ((obpos_app_0_.fin_financial_account_id)::text = (fin_financ1_.fin_financial_account_id)::text)
  • Buffers: shared hit=7865
10. 10.477 10.477 ↓ 1.0 61,444 1

Seq Scan on obpos_app_payment obpos_app_0_ (cost=0.00..3,861.37 rows=61,437 width=140) (actual time=0.003..10.477 rows=61,444 loops=1)

  • Buffers: shared hit=3247
11. 22.549 50.400 ↑ 1.0 109,784 1

Hash (cost=5,717.29..5,717.29 rows=109,929 width=37) (actual time=50.399..50.400 rows=109,784 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 8422kB
  • Buffers: shared hit=4618
12. 27.851 27.851 ↑ 1.0 109,784 1

Seq Scan on fin_financial_account fin_financ1_ (cost=0.00..5,717.29 rows=109,929 width=37) (actual time=0.011..27.851 rows=109,784 loops=1)

  • Buffers: shared hit=4618
13. 0.027 0.058 ↑ 1.0 175 1

Hash (cost=4.75..4.75 rows=175 width=8) (actual time=0.058..0.058 rows=175 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
  • Buffers: shared hit=3
14. 0.031 0.031 ↑ 1.0 175 1

Seq Scan on c_currency currency2_ (cost=0.00..4.75 rows=175 width=8) (actual time=0.005..0.031 rows=175 loops=1)

  • Buffers: shared hit=3
15. 1.763 4.130 ↓ 1.0 6,690 1

Hash (cost=479.85..479.85 rows=6,685 width=99) (actual time=4.130..4.130 rows=6,690 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 920kB
  • Buffers: shared hit=413
16. 2.367 2.367 ↓ 1.0 6,690 1

Seq Scan on obpos_applications obpos_appl3_ (cost=0.00..479.85 rows=6,685 width=99) (actual time=0.004..2.367 rows=6,690 loops=1)

  • Buffers: shared hit=413
17. 0.114 0.344 ↑ 1.0 588 1

Hash (cost=73.97..73.97 rows=597 width=36) (actual time=0.344..0.344 rows=588 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 47kB
  • Buffers: shared hit=68
18. 0.230 0.230 ↑ 1.0 588 1

Seq Scan on ad_org organizati4_ (cost=0.00..73.97 rows=597 width=36) (actual time=0.005..0.230 rows=588 loops=1)

  • Buffers: shared hit=68
19. 0.028 0.057 ↑ 1.0 175 1

Hash (cost=4.75..4.75 rows=175 width=4) (actual time=0.057..0.057 rows=175 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
  • Buffers: shared hit=3
20. 0.029 0.029 ↑ 1.0 175 1

Seq Scan on c_currency currency5_ (cost=0.00..4.75 rows=175 width=4) (actual time=0.005..0.029 rows=175 loops=1)

  • Buffers: shared hit=3
21. 3.449 13.687 ↓ 1.0 16,673 1

Hash (cost=1,397.63..1,397.63 rows=16,663 width=35) (actual time=13.687..13.687 rows=16,673 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1347kB
  • Buffers: shared hit=1231
22. 10.238 10.238 ↓ 1.0 16,673 1

Seq Scan on obpos_app_payment_type obpos_app_17_ (cost=0.00..1,397.63 rows=16,663 width=35) (actual time=0.011..10.238 rows=16,673 loops=1)

  • Buffers: shared hit=1231
23. 0.004 0.176 ↑ 1.0 1 1

Hash (cost=18.11..18.11 rows=1 width=33) (actual time=0.176..0.176 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=30
24. 0.002 0.172 ↓ 2.0 2 1

Nested Loop (cost=2.27..18.11 rows=1 width=33) (actual time=0.124..0.172 rows=2 loops=1)

  • Buffers: shared hit=30
25. 0.002 0.116 ↓ 2.0 2 1

Nested Loop (cost=1.70..15.79 rows=1 width=33) (actual time=0.092..0.116 rows=2 loops=1)

  • Buffers: shared hit=20
26. 0.003 0.062 ↓ 2.0 2 1

Nested Loop (cost=1.13..13.47 rows=1 width=33) (actual time=0.060..0.062 rows=2 loops=1)

  • Buffers: shared hit=10
27. 0.035 0.035 ↑ 1.0 1 1

Index Scan using fin_paym_sch_ord_idx on fin_payment_schedule fin_paymen21_ (cost=0.56..2.78 rows=1 width=33) (actual time=0.035..0.035 rows=1 loops=1)

  • Index Cond: ((c_order_id)::text = 'F6AC5069FBA3FBCE5AC8C778B49A508E'::text)
  • Buffers: shared hit=5
28. 0.024 0.024 ↑ 4.0 2 1

Index Scan using fin_pay_scheduledetail_or on fin_payment_scheduledetail fin_paymen18_ (cost=0.57..10.61 rows=8 width=66) (actual time=0.023..0.024 rows=2 loops=1)

  • Index Cond: ((fin_payment_schedule_order)::text = (fin_paymen21_.fin_payment_schedule_id)::text)
  • Buffers: shared hit=5
29. 0.052 0.052 ↑ 1.0 1 2

Index Scan using fin_payment_detail_key on fin_payment_detail fin_paymen19_ (cost=0.57..2.32 rows=1 width=66) (actual time=0.026..0.026 rows=1 loops=2)

  • Index Cond: ((fin_payment_detail_id)::text = (fin_paymen18_.fin_payment_detail_id)::text)
  • Buffers: shared hit=10
30. 0.054 0.054 ↑ 1.0 1 2

Index Scan using fin_payment_key on fin_payment fin_paymen20_ (cost=0.57..2.32 rows=1 width=66) (actual time=0.027..0.027 rows=1 loops=2)

  • Index Cond: ((fin_payment_id)::text = (fin_paymen19_.fin_payment_id)::text)
  • Buffers: shared hit=10
Planning time : 5.172 ms
Execution time : 193.736 ms