explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s5Gv

Settings
# exclusive inclusive rows x rows loops node
1. 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=)

  • Hash Cond: ((("outer".tag_name)::text = ("inner".tag_name)::text) AND (("outer"."datasource")::text = ("inner"."datasource")::text))
2. 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=)

  • Hash Cond: (checksum("outer".unitofmeasure) = "inner".uom_id)
3. 0.000 0.000 ↓ 0.0

XN Partition Loop (cost=0.00..550,000,020.00 rows=10,000,000,000 width=307) (actual rows= loops=)

4. 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=)

  • Filter: ((("month")::text = '01'::text) AND (("year")::double precision = 2019::double precision))
5. 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=)

6. 0.000 0.000 ↓ 0.0

S3 Seq Scan ida_eap_prd_tbl_hist.pdc_snsr_wts wts location:"s3://den-prd-fra-mosaic-archive/ORC/wts" format:ORC_FILE (cost=0.00..175,000,000.00 rows=10,000,000,000 width=244) (actual rows= loops=)

  • Filter: ((tag_timestamp_utc < '2019-01-10 00:00:00'::timestamp without time zone) AND (tag_timestamp_utc >= '2019-01-09 00:00:00'::timestamp without time zone) AND (status = true))
7. 0.000 0.000 ↓ 0.0

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

8. 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=)

9. 0.000 0.000 ↓ 0.0

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

10. 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=)

  • Hash Cond: (("outer".id)::text = ("inner".aeic)::text)
11. 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=)

  • Hash Cond: (("outer".kpi_name)::text = ("inner".gpn)::text)
12. 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=)

  • Filter: (((fact_id = 4) AND ((kpi_type)::text = 'gpn'::text)) OR (hashed subplan))
13.          

SubPlan (forXN Seq Scan on dim_kpi_v2 k)

14. 0.000 0.000 ↓ 0.0

XN Result (cost=0.00..0.02 rows=1 width=4) (actual rows= loops=)

  • One-Time Filter: NULL::boolean
15. 0.000 0.000 ↓ 0.0

XN Subquery Scan etl_kpi_filter (cost=0.00..0.02 rows=1 width=4) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

XN Result (cost=0.00..0.01 rows=1 width=0) (actual rows= loops=)

  • One-Time Filter: false
17. 0.000 0.000 ↓ 0.0

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

18. 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=)

  • Filter: ((mapping_end > '2019-01-10 00:00:00'::timestamp without time zone) AND (mapping_start <= '2019-01-09 00:00:00'::timestamp without time zone))
19. 0.000 0.000 ↓ 0.0

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

20. 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=)

  • Filter: ((app_id = 1) OR (hashed subplan))
21.          

SubPlan (forXN Seq Scan on dim_unit u)

22. 0.000 0.000 ↓ 0.0

XN Result (cost=0.00..0.02 rows=1 width=22) (actual rows= loops=)

  • One-Time Filter: NULL::boolean
23. 0.000 0.000 ↓ 0.0

XN Subquery Scan etl_unit_filter (cost=0.00..0.02 rows=1 width=22) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

XN Result (cost=0.00..0.01 rows=1 width=0) (actual rows= loops=)

  • One-Time Filter: false