explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nyvm

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

XN HashAggregate (cost=910,093,058.66..910,093,238.66 rows=8,000 width=201) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_ALL_NONE (cost=550,010,860.11..910,092,267.29 rows=79,137 width=201) (actual rows= loops=)

  • Hash Cond: ((("outer".derived_col5)::text = ("inner".tag_name)::text) AND (("outer"."datasource")::text = ("inner"."datasource")::text))
  • Remarks: Derives subplan 2
3. 0.000 0.000 ↓ 0.0

XN Partition Loop (cost=550,000,000.00..710,080,020.00 rows=8,000,000,000 width=315) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

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

  • Filter: (("year" = 2019) AND (("month" = '01'::bpchar) OR ("month" = '02'::bpchar) OR ("month" = '03'::bpchar)) AND (subplan 2: (($0)::text = ("datasource")::text)))
5. 0.000 0.000 ↓ 0.0

XN S3 Query Scan w (cost=275,000,000.00..355,040,000.00 rows=8,000,000,000 width=252) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

S3 HashAggregate (cost=275,000,000.00..275,040,000.00 rows=8,000,000,000 width=244) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

S3 Seq Scan ida_eap_prd_tbl_hist.pdc_snsr_wts w 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: ((derived_col2 < '2019-04-01 00:00:00'::timestamp without time zone) AND (derived_col2 >= '2019-01-01 00:00:00'::timestamp without time zone))
8. 0.000 0.000 ↓ 0.0

XN Hash (cost=10,860.10..10,860.10 rows=1 width=31) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

XN Seq Scan on pdc_gpn_map g (cost=0.00..10,860.10 rows=1 width=31) (actual rows= loops=)

  • Filter: ((((gpn)::text = 'HRSG_LPSTM_FLOW1'::text) OR ((gpn)::text = 'IGVP'::text) OR ((gpn)::text = 'MW'::text)) AND ((id)::text = '310467'::text) AND (mapping_end >= '2019-04-01 00:00:00'::timestamp without time zone) AND (mapping_start <= '2019-01-01 00:00:00'::timestamp without time zone))