explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YOTI

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

XN Partition Loop (cost=0.00..550,000,017.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..17.50 rows=1 width=75) (actual rows= loops=)

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

XN S3 Query Scan pdc_snsr_wts (cost=0.00..275,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..175,000,000.00 rows=10,000,000,000 width=245) (actual rows= loops=)

  • Filter: (((tag_name)::text = '@10MBY10CE901_XQ01'::text) AND (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))