explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0JW6

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

XN Partition Loop (cost=0.00..650,000,022.50 rows=10,000,000,000 width=320) (actual rows= loops=)

2. 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=75) (actual rows= loops=)

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

XN S3 Query Scan pdc_snsr_wts (cost=0.00..325,000,000.00 rows=10,000,000,000 width=245) (actual rows= loops=)

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