explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7S4Z

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.069 ↓ 0.0 0 1

Group (cost=14,372.41..14,372.93 rows=1 width=144) (actual time=0.069..0.069 rows=0 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=20
2. 0.013 0.069 ↓ 0.0 0 1

Sort (cost=14,372.41..14,372.42 rows=1 width=144) (actual time=0.069..0.069 rows=0 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=20
3. 0.004 0.056 ↓ 0.0 0 1

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

  • Hash Cond: ((obpos_app_0_.fin_financial_account_id)::text = (fin_paymen20_.em_obdico_fin_account_id)::text)
  • Buffers: shared hit=20
4. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=9,356.04..14,192.50 rows=61,437 width=187) (never executed)

  • Hash Cond: ((obpos_app_0_.obpos_app_payment_type_id)::text = (obpos_app_17_.obpos_app_payment_type_id)::text)
5. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=7,750.12..12,425.26 rows=61,437 width=218) (never executed)

  • Hash Cond: ((organizati4_.c_currency_id)::text = (currency5_.c_currency_id)::text)
6. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=7,743.19..12,254.81 rows=61,437 width=218) (never executed)

  • Hash Cond: ((obpos_appl3_.ad_org_id)::text = (organizati4_.ad_org_id)::text)
7. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=7,661.75..12,010.95 rows=61,437 width=214) (never executed)

  • Hash Cond: ((obpos_app_0_.obpos_applications_id)::text = (obpos_appl3_.obpos_applications_id)::text)
8. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=7,098.34..11,286.17 rows=61,437 width=181) (never executed)

  • Hash Cond: ((fin_financ1_.c_currency_id)::text = (currency2_.c_currency_id)::text)
9. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=7,091.40..11,114.06 rows=61,437 width=177) (never executed)

  • Hash Cond: ((obpos_app_0_.fin_financial_account_id)::text = (fin_financ1_.fin_financial_account_id)::text)
10. 0.000 0.000 ↓ 0.0 0

Seq Scan on obpos_app_payment obpos_app_0_ (cost=0.00..3,861.37 rows=61,437 width=140) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,717.29..5,717.29 rows=109,929 width=37) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Seq Scan on fin_financial_account fin_financ1_ (cost=0.00..5,717.29 rows=109,929 width=37) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Hash (cost=4.75..4.75 rows=175 width=8) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Seq Scan on c_currency currency2_ (cost=0.00..4.75 rows=175 width=8) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Hash (cost=479.85..479.85 rows=6,685 width=99) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Seq Scan on obpos_applications obpos_appl3_ (cost=0.00..479.85 rows=6,685 width=99) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Hash (cost=73.97..73.97 rows=597 width=36) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Seq Scan on ad_org organizati4_ (cost=0.00..73.97 rows=597 width=36) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Hash (cost=4.75..4.75 rows=175 width=4) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Seq Scan on c_currency currency5_ (cost=0.00..4.75 rows=175 width=4) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,397.63..1,397.63 rows=16,663 width=35) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Seq Scan on obpos_app_payment_type obpos_app_17_ (cost=0.00..1,397.63 rows=16,663 width=35) (never executed)

23. 0.001 0.052 ↓ 0.0 0 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=20
24. 0.000 0.051 ↑ 1.0 1 1

Nested Loop (cost=2.27..18.11 rows=1 width=33) (actual time=0.050..0.051 rows=1 loops=1)

  • Buffers: shared hit=20
25. 0.001 0.041 ↑ 1.0 1 1

Nested Loop (cost=1.70..15.79 rows=1 width=33) (actual time=0.039..0.041 rows=1 loops=1)

  • Buffers: shared hit=15
26. 0.003 0.029 ↑ 1.0 1 1

Nested Loop (cost=1.13..13.47 rows=1 width=33) (actual time=0.027..0.029 rows=1 loops=1)

  • Buffers: shared hit=10
27. 0.014 0.014 ↑ 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.013..0.014 rows=1 loops=1)

  • Index Cond: ((c_order_id)::text = '0307680E9F3815B62602603F9EE01043'::text)
  • Buffers: shared hit=5
28. 0.012 0.012 ↑ 8.0 1 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.011..0.012 rows=1 loops=1)

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

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.011..0.011 rows=1 loops=1)

  • Index Cond: ((fin_payment_detail_id)::text = (fin_paymen18_.fin_payment_detail_id)::text)
  • Buffers: shared hit=5
30. 0.010 0.010 ↑ 1.0 1 1

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

  • Index Cond: ((fin_payment_id)::text = (fin_paymen19_.fin_payment_id)::text)
  • Buffers: shared hit=5
Planning time : 1.849 ms
Execution time : 0.149 ms