explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rEsU

Settings
# exclusive inclusive rows x rows loops node
1. 20,439.149 557,888.871 ↓ 56.3 7,404,082 1

Nested Loop (cost=1,000.28..22,241,388.88 rows=131,553 width=2,476) (actual time=220,978.149..557,888.871 rows=7,404,082 loops=1)

2. 64,915.711 500,600.503 ↓ 23.1 12,283,073 1

Subquery Scan on t1 (cost=1,000.00..22,080,311.77 rows=531,720 width=2,476) (actual time=220,978.102..500,600.503 rows=12,283,073 loops=1)

  • Filter: ((t1.local_15min >= '2018-01-01 00:00:00-06'::timestamp with time zone) AND (t1.local_15min < '2019-01-01 00:00:00-06'::timestamp with time zone))
  • Rows Removed by Filter: 93932862
3. 112,586.685 435,684.792 ↑ 1.0 106,215,935 1

Append (cost=1,000.00..20,485,150.42 rows=106,344,090 width=2,476) (actual time=0.894..435,684.792 rows=106,215,935 loops=1)

4. 159,668.600 312,076.975 ↑ 1.0 97,706,389 1

Subquery Scan on *SELECT* 1 (cost=1,000.00..19,628,599.97 rows=97,827,640 width=2,424) (actual time=0.892..312,076.975 rows=97,706,389 loops=1)

5. 58,128.215 152,408.375 ↑ 1.0 97,706,389 1

Gather (cost=1,000.00..18,405,754.47 rows=97,827,640 width=2,424) (actual time=0.886..152,408.375 rows=97,706,389 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 94,280.160 94,280.160 ↑ 1.3 32,568,796 3

Parallel Seq Scan on egauge_15min_wide_real_2012to2018 (cost=0.00..8,621,990.47 rows=40,761,517 width=2,424) (actual time=0.080..94,280.160 rows=32,568,796 loops=3)

7. 11,021.132 11,021.132 ↑ 1.0 8,509,546 1

Seq Scan on egauge_15min_wide_real_2019 (cost=0.00..239,665.50 rows=8,516,450 width=310) (actual time=0.019..11,021.132 rows=8,509,546 loops=1)

8. 36,849.219 36,849.219 ↑ 1.0 1 12,283,073

Index Scan using dataport_metadata_dataid_idx on metadata (cost=0.28..0.30 rows=1 width=2) (actual time=0.003..0.003 rows=1 loops=12,283,073)

  • Index Cond: (dataid = t1.dataid)
  • Filter: ((active_record = 'yes'::text) AND (air1 = 'yes'::text) AND ((state)::text = 'Texas'::text))
  • Rows Removed by Filter: 0
Planning time : 0.976 ms