explain.depesz.com

PostgreSQL's explain analyze made readable

Result: txBg

Settings
# exclusive inclusive rows x rows loops node
1. 0.166 0.423 ↑ 427.0 12 1

HashAggregate (cost=674.98..764.65 rows=5,124 width=512) (actual time=0.393..0.423 rows=12 loops=1)

  • Group Key: pe.package_code, pe.input_batch_name, pe.date, pe.output_package_type_id, pe.legal_entity_id, pe.legal_entity_country, pa.amount_currency, opm.package_code
2. 0.055 0.257 ↑ 67.4 76 1

Hash Right Join (cost=155.20..482.83 rows=5,124 width=456) (actual time=0.178..0.257 rows=76 loops=1)

  • Hash Cond: (pa.posting_element_id = pe.id)
3. 0.012 0.048 ↑ 19.9 76 1

Append (cost=0.00..143.74 rows=1,516 width=51) (actual time=0.020..0.048 rows=76 loops=1)

4. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on posting_amount_2018_q1 pa (cost=0.00..11.20 rows=120 width=52) (actual time=0.001..0.001 rows=0 loops=1)

5. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on posting_amount_2018_q2 pa_1 (cost=0.00..11.20 rows=120 width=52) (actual time=0.001..0.001 rows=0 loops=1)

6. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on posting_amount_2018_q3 pa_2 (cost=0.00..11.20 rows=120 width=52) (actual time=0.001..0.001 rows=0 loops=1)

7. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on posting_amount_2018_q4 pa_3 (cost=0.00..11.20 rows=120 width=52) (actual time=0.001..0.001 rows=0 loops=1)

8. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on posting_amount_2019_q1 pa_4 (cost=0.00..11.20 rows=120 width=52) (actual time=0.001..0.001 rows=0 loops=1)

9. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on posting_amount_2019_q2 pa_5 (cost=0.00..11.20 rows=120 width=52) (actual time=0.001..0.001 rows=0 loops=1)

10. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on posting_amount_2019_q3 pa_6 (cost=0.00..11.20 rows=120 width=52) (actual time=0.001..0.001 rows=0 loops=1)

11. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on posting_amount_2019_q4 pa_7 (cost=0.00..11.20 rows=120 width=52) (actual time=0.002..0.002 rows=0 loops=1)

12. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on posting_amount_2020_q1 pa_8 (cost=0.00..11.20 rows=120 width=52) (actual time=0.001..0.001 rows=0 loops=1)

13. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on posting_amount_2020_q2 pa_9 (cost=0.00..11.20 rows=120 width=52) (actual time=0.001..0.001 rows=0 loops=1)

14. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on posting_amount_2020_q3 pa_10 (cost=0.00..11.20 rows=120 width=52) (actual time=0.001..0.001 rows=0 loops=1)

15. 0.022 0.022 ↑ 1.0 76 1

Seq Scan on posting_amount_2020_q4 pa_11 (cost=0.00..1.76 rows=76 width=26) (actual time=0.005..0.022 rows=76 loops=1)

16. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on posting_amount_default pa_12 (cost=0.00..11.20 rows=120 width=52) (actual time=0.002..0.002 rows=0 loops=1)

17. 0.027 0.154 ↑ 8.9 76 1

Hash (cost=146.75..146.75 rows=676 width=438) (actual time=0.154..0.154 rows=76 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 22kB
18. 0.041 0.127 ↑ 8.9 76 1

Hash Left Join (cost=11.80..146.75 rows=676 width=438) (actual time=0.046..0.127 rows=76 loops=1)

  • Hash Cond: ((pe.output_package_type_id)::text = (opm.package_id)::text)
19. 0.012 0.071 ↑ 8.9 76 1

Append (cost=0.00..133.14 rows=676 width=418) (actual time=0.027..0.071 rows=76 loops=1)

20. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on posting_element_2018_q1 pe (cost=0.00..10.50 rows=50 width=454) (actual time=0.003..0.004 rows=0 loops=1)

21. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on posting_element_2018_q2 pe_1 (cost=0.00..10.50 rows=50 width=454) (actual time=0.001..0.001 rows=0 loops=1)

22. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on posting_element_2018_q3 pe_2 (cost=0.00..10.50 rows=50 width=454) (actual time=0.001..0.001 rows=0 loops=1)

23. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on posting_element_2018_q4 pe_3 (cost=0.00..10.50 rows=50 width=454) (actual time=0.001..0.001 rows=0 loops=1)

24. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on posting_element_2019_q1 pe_4 (cost=0.00..10.50 rows=50 width=454) (actual time=0.001..0.001 rows=0 loops=1)

25. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on posting_element_2019_q2 pe_5 (cost=0.00..10.50 rows=50 width=454) (actual time=0.002..0.002 rows=0 loops=1)

26. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on posting_element_2019_q3 pe_6 (cost=0.00..10.50 rows=50 width=454) (actual time=0.001..0.001 rows=0 loops=1)

27. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on posting_element_2019_q4 pe_7 (cost=0.00..10.50 rows=50 width=454) (actual time=0.001..0.001 rows=0 loops=1)

28. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on posting_element_2020_q1 pe_8 (cost=0.00..10.50 rows=50 width=454) (actual time=0.001..0.002 rows=0 loops=1)

29. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on posting_element_2020_q2 pe_9 (cost=0.00..10.50 rows=50 width=454) (actual time=0.001..0.001 rows=0 loops=1)

30. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on posting_element_2020_q3 pe_10 (cost=0.00..10.50 rows=50 width=454) (actual time=0.002..0.002 rows=0 loops=1)

31. 0.041 0.041 ↑ 1.0 76 1

Seq Scan on posting_element_2020_q4 pe_11 (cost=0.00..3.76 rows=76 width=134) (actual time=0.007..0.041 rows=76 loops=1)

32. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on posting_element_default pe_12 (cost=0.00..10.50 rows=50 width=454) (actual time=0.001..0.001 rows=0 loops=1)

33. 0.007 0.015 ↑ 3.5 23 1

Hash (cost=10.80..10.80 rows=80 width=52) (actual time=0.014..0.015 rows=23 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
34. 0.008 0.008 ↑ 3.5 23 1

Seq Scan on output_package_type_mapping opm (cost=0.00..10.80 rows=80 width=52) (actual time=0.003..0.008 rows=23 loops=1)