explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pc6w

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

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

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

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

6. 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))