explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JfsF

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.221 ↑ 1.0 1 1

Nested Loop (cost=0.71..119.47 rows=1 width=219) (actual time=0.211..0.221 rows=1 loops=1)

2. 0.001 0.203 ↑ 1.0 1 1

Nested Loop (cost=0.71..116.75 rows=1 width=156) (actual time=0.196..0.203 rows=1 loops=1)

3. 0.007 0.170 ↑ 1.0 1 1

Nested Loop (cost=0.43..108.45 rows=1 width=143) (actual time=0.163..0.170 rows=1 loops=1)

4. 0.002 0.115 ↓ 3.0 6 1

Append (cost=0.00..91.51 rows=2 width=115) (actual time=0.047..0.115 rows=6 loops=1)

5. 0.000 0.001 ↓ 0.0 0 1

Seq Scan on meteocode_elmts (cost=0.00..0.00 rows=1 width=196) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((region_id = 230) AND (wx_element = 32) AND ((value)::text = '0'::text) AND (valid_time = '2018-09-05 15:00:00'::timestamp without time zone) AND (((SubPlan 2))::text = 'CELSIUS'::text))
6.          

SubPlan (for Seq Scan)

7. 0.018 0.018 ↑ 1.0 1 6

Seq Scan on meteocode_units_lookup meteocode_units_lookup_1 (cost=0.00..1.09 rows=1 width=67) (actual time=0.002..0.003 rows=1 loops=6)

  • Filter: (id = meteocode_elmts.unit_id)
  • Rows Removed by Filter: 6
8. 0.094 0.112 ↓ 6.0 6 1

Index Scan using meteocode_elmts_2018_09_region_id_wx_element_valid_time_idx on meteocode_elmts_2018_09 (cost=0.56..91.51 rows=1 width=34) (actual time=0.045..0.112 rows=6 loops=1)

  • Index Cond: ((region_id = 230) AND (wx_element = 32) AND (valid_time = '2018-09-05 15:00:00'::timestamp without time zone))
  • Filter: (((value)::text = '0'::text) AND (((SubPlan 2))::text = 'CELSIUS'::text))
  • Rows Removed by Filter: 20
9.          

SubPlan (for Index Scan)

10. 0.018 0.018 ↑ 1.0 1 6

Seq Scan on meteocode_units_lookup meteocode_units_lookup_1 (cost=0.00..1.09 rows=1 width=67) (actual time=0.002..0.003 rows=1 loops=6)

  • Filter: (id = meteocode_elmts_2018_09.unit_id)
  • Rows Removed by Filter: 6
11. 0.048 0.048 ↓ 0.0 0 6

Index Scan using meteocode_bltns_meteocode_id_key on meteocode_bltns (cost=0.43..8.46 rows=1 width=44) (actual time=0.008..0.008 rows=0 loops=6)

  • Index Cond: (meteocode_id = meteocode_elmts.meteocode)
  • Filter: (((origin)::text = 'OFFICIAL'::text) AND ((timezone)::text = 'EST5EDT'::text) AND (flag = 'REG'::bpchar) AND (issue_time = '2018-09-04 05:00:00'::timestamp without time zone) AND (next_forecast = '2018-09-04 11:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1
12. 0.032 0.032 ↑ 1.0 1 1

Index Only Scan using region_lookup_rid on region_lookup (cost=0.28..8.30 rows=1 width=21) (actual time=0.032..0.032 rows=1 loops=1)

  • Index Cond: ((region_id = 'PU-REG-WNT-00049'::text) AND (id = 230))
  • Heap Fetches: 1
13. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on meteocode_elmts_lookup (cost=0.00..1.61 rows=1 width=71) (actual time=0.009..0.010 rows=1 loops=1)

  • Filter: ((id = 32) AND ((wx_element)::text = 'TEMP_VALEUR1'::text))
  • Rows Removed by Filter: 40
14.          

SubPlan (for Nested Loop)

15. 0.002 0.002 ↑ 1.0 1 1

Seq Scan on meteocode_units_lookup (cost=0.00..1.09 rows=1 width=67) (actual time=0.001..0.002 rows=1 loops=1)

  • Filter: (id = meteocode_elmts.unit_id)
  • Rows Removed by Filter: 6
Total runtime : 0.431 ms