explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bwGS

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

XN Merge (cost=1,000,651,901,121.13..1,000,651,901,141.13 rows=8,000 width=201) (actual rows= loops=)

  • Merge Key: pdc_snsr_wts."datasource", (date_trunc('hour'::text, pdc_snsr_wts.derived_col1) + ((((pgdate_part('min'::text, pdc_snsr_wts.derived_col1))::integer / 1))::double precision * '00:01:00'::interval))
2. 0.000 0.000 ↓ 0.0

XN Network (cost=1,000,651,901,121.13..1,000,651,901,141.13 rows=8,000 width=201) (actual rows= loops=)

  • Send to leader
3. 0.000 0.000 ↓ 0.0

XN Sort (cost=1,000,651,901,121.13..1,000,651,901,141.13 rows=8,000 width=201) (actual rows= loops=)

  • Sort Key: pdc_snsr_wts."datasource", (date_trunc('hour'::text, pdc_snsr_wts.derived_col1) + ((((pgdate_part('min'::text, pdc_snsr_wts.derived_col1))::integer / 1))::double precision * '00:01:00'::interval))
4. 0.000 0.000 ↓ 0.0

XN HashAggregate (cost=651,900,422.50..651,900,602.50 rows=8,000 width=201) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

XN Partition Loop (cost=650,000,000.00..651,500,422.50 rows=40,000,000 width=201) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

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

  • Filter: ((("datasource")::text = 'SEVE10'::text) AND ("year" = 2019) AND (("month" = '01'::bpchar) OR ("month" = '02'::bpchar) OR ("month" = '03'::bpchar)))
7. 0.000 0.000 ↓ 0.0

XN S3 Query Scan pdc_snsr_wts (cost=325,000,000.00..325,400,200.00 rows=40,000,000 width=138) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

S3 HashAggregate (cost=325,000,000.00..325,000,200.00 rows=40,000,000 width=130) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

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

  • Filter: ((((tag_name)::text = '@10LBA80CF001_XQ01'::text) OR ((tag_name)::text = '@10MBY10CE901_XQ01'::text) OR ((tag_name)::text = '@10MBY10DT040_XQ02'::text)) AND (tag_timestamp_utc < '2019-04-01 00:00:00'::timestamp without time zone) AND (tag_timestamp_utc >= '2019-01-01 00:00:00'::timestamp without time zone))