explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gRF9

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

XN Hash Join DS_DIST_ALL_NONE (cost=7,603.20..750,007,869.81 rows=10,992 width=232) (actual rows= loops=)

  • Hash Cond: (("outer".id)::text = ("inner".aeic)::text)
2. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_ALL_NONE (cost=7,602.08..750,007,621.37 rows=10,992 width=209) (actual rows= loops=)

  • Hash Cond: ((("outer".tag_name)::text = ("inner".tag_name)::text) AND (("outer"."datasource")::text = ("inner"."datasource")::text))
  • Join Filter: (("inner".mapping_start <= "outer".tag_timestamp_utc) AND ("inner".mapping_end > "outer".tag_timestamp_utc))
  • Remarks: Derives subplan 13
3. 0.000 0.000 ↓ 0.0

XN Partition Loop (cost=0.00..500,000,015.00 rows=10,000,000,000 width=319) (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..15.00 rows=1 width=75) (actual rows= loops=)

  • Filter: (("month" = '05'::bpchar) AND ("year" = 2019) AND (subplan 13: (($3)::text = ("datasource")::text)))
5. 0.000 0.000 ↓ 0.0

XN S3 Query Scan wts (cost=0.00..250,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..150,000,000.00 rows=10,000,000,000 width=244) (actual rows= loops=)

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

XN Hash (cost=7,602.07..7,602.07 rows=1 width=114) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

XN Seq Scan on pdc_gpn_map m (cost=0.00..7,602.07 rows=1 width=114) (actual rows= loops=)

  • Filter: (((gpn)::text = 'MW'::text) AND ('310467'::text = (id)::text) AND ((id_type)::text = 'AEIC'::text))
9. 0.000 0.000 ↓ 0.0

XN Hash (cost=1.12..1.12 rows=1 width=33) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

XN Seq Scan on units u (cost=0.00..1.12 rows=1 width=33) (actual rows= loops=)

  • Filter: ((aeic)::text = '310467'::text)