explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ph8n

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

XN Merge Join DS_DIST_NONE (cost=54,722,132,950,997.47..1,858,086,695,941,126.50 rows=19,058,076,243,171,596 width=312) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_NONE (cost=16,968,434,368.43..72,448,200,333,712.84 rows=36,578,674,048,043 width=89) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

XN Hash Join DS_BCAST_INNER (cost=9,309,515,707.94..57,090,298,795,877.70 rows=1,313,635,222,683 width=48) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

XN Seq Scan on position_dl_tbl p (cost=0.00..287,686,092.61 rows=19,179,072,841 width=36) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

XN Hash (cost=9,308,092,155.05..9,308,092,155.05 rows=284,710,578 width=12) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_NONE (cost=2,801,136.70..9,308,092,155.05 rows=284,710,578 width=12) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

XN Seq Scan on instrument_dl dl (cost=0.00..91,828,529.64 rows=6,121,901,977 width=12) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

XN Hash (cost=2,427,928.90..2,427,928.90 rows=74,641,560 width=8) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_ALL_NONE (cost=2,078.20..2,427,928.90 rows=74,641,560 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

XN Seq Scan on instrument_st1_tbl st1 (cost=0.00..746,415.60 rows=74,641,560 width=12) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

XN Hash (cost=1,662.56..1,662.56 rows=166,256 width=4) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

XN Seq Scan on obligor_lu_tbl o (cost=0.00..1,662.56 rows=166,256 width=4) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

XN Hash (cost=7,656,001,828.38..7,656,001,828.38 rows=583,366,423 width=41) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_NONE (cost=3,668,061.70..7,656,001,828.38 rows=583,366,423 width=41) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_NONE (cost=866,925.00..7,224,711,271.17 rows=284,710,578 width=29) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

XN Seq Scan on instrument_dl volt_dt_0 (cost=0.00..91,828,529.64 rows=6,121,901,977 width=16) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

XN Hash (cost=577,950.00..577,950.00 rows=57,795,000 width=21) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

XN Seq Scan on instrument_rc1_tbl volt_dt_1 (cost=0.00..577,950.00 rows=57,795,000 width=21) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

XN Hash (cost=2,427,928.90..2,427,928.90 rows=74,641,560 width=20) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_ALL_NONE (cost=2,078.20..2,427,928.90 rows=74,641,560 width=20) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

XN Seq Scan on instrument_st1_tbl volt_dt_2 (cost=0.00..746,415.60 rows=74,641,560 width=24) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

XN Hash (cost=1,662.56..1,662.56 rows=166,256 width=4) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

XN Seq Scan on obligor_lu_tbl volt_dt_3 (cost=0.00..1,662.56 rows=166,256 width=4) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_NONE (cost=122,438,302.52..184,836,304,765.92 rows=189,282,932,121 width=279) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

XN Hash Join DS_BCAST_INNER (cost=263.00..93,755,276,173.37 rows=742,831,923 width=263) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

XN Seq Scan on position_dl_tbl p (cost=0.00..287,686,092.61 rows=19,179,072,841 width=52) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

XN Hash (cost=197.25..197.25 rows=13,150 width=211) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

XN Seq Scan on container_details (cost=0.00..197.25 rows=13,150 width=211) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

XN Hash (cost=91,828,529.64..91,828,529.64 rows=6,121,901,977 width=16) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

XN Seq Scan on instrument_dl dl (cost=0.00..91,828,529.64 rows=6,121,901,977 width=16) (actual rows= loops=)