explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rxqF

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

XN Hash Right Join DS_DIST_BOTH (cost=92,661,180.61..71,326,169,234,706.52 rows=347,108,686 width=214) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

XN Subquery Scan d1 (cost=11,113.70..11,113,029,203.70 rows=797,644,833 width=196) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

XN Hash Join DS_BCAST_INNER (cost=11,113.70..11,105,052,755.37 rows=797,644,833 width=169) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

XN Hash Left Join DS_BCAST_INNER (cost=3.90..1,203,454,508.95 rows=10,365,448,505 width=332) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

XN Hash (cost=3.12..3.12 rows=312 width=29) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

XN Seq Scan on uom_cnvs_map uom (cost=0.00..3.12 rows=312 width=29) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

XN Hash (cost=11,071.85..11,071.85 rows=7,590 width=45) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_ALL_NONE (cost=7,265.78..11,071.85 rows=7,590 width=45) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_ALL_NONE (cost=7,260.05..10,412.91 rows=25,658 width=45) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

XN Seq Scan on dim_kpi_v2 k (cost=0.02..7.50 rows=217 width=22) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

XN Hash (cost=6,304.08..6,304.08 rows=382,377 width=57) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

XN Seq Scan on pdc_gpn_map (cost=0.00..6,304.08 rows=382,377 width=57) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

XN Hash (cost=5.02..5.02 rows=289 width=10) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

XN Seq Scan on dim_unit u (cost=0.02..5.02 rows=289 width=10) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

XN Hash (cost=92,582,336.86..92,582,336.86 rows=9,030,672 width=44) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

XN Nested Loop DS_BCAST_INNER (cost=0.04..92,582,336.86 rows=9,030,672 width=44) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

XN Nested Loop DS_BCAST_INNER (cost=0.04..69,361,723.42 rows=62,713 width=36) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

XN Seq Scan on dim_kpi_v2 k (cost=0.02..7.50 rows=217 width=22) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

XN Seq Scan on dim_unit u (cost=0.02..5.02 rows=289 width=14) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

XN Seq Scan on time_series_1547107217096 (cost=0.00..1.44 rows=144 width=8) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

XN Seq Scan PartitionInfo of ida_eap_prd_tbl_hist.pdc_snsr_wts wts (cost=0.00..20.00 rows=1 width=63) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

XN S3 Query Scan wts (cost=0.00..275,000,000.00 rows=10,000,000,000 width=244) (actual rows= loops=)