explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZFX

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1.108 ↓ 0.0 0 1

Insert on all_stations (cost=10,000,000,000.43..10,000,003,780.11 rows=257 width=264) (actual time=1.108..1.108 rows=0 loops=1)

2. 0.042 1.107 ↓ 0.0 0 1

Nested Loop Anti Join (cost=10,000,000,000.43..10,000,003,780.11 rows=257 width=264) (actual time=1.107..1.107 rows=0 loops=1)

3. 0.036 0.036 ↑ 1.0 343 1

Seq Scan on temp_table_2 tl (cost=10,000,000,000.00..10,000,000,007.43 rows=343 width=64) (actual time=0.007..0.036 rows=343 loops=1)

4. 0.000 1.029 ↑ 4.0 1 343

Append (cost=0.43..14.45 rows=4 width=12) (actual time=0.003..0.003 rows=1 loops=343)

5. 1.029 1.029 ↑ 4.0 1 343

Index Scan using glos_45176_m_date_idx on glos_45176 t (cost=0.43..14.45 rows=4 width=12) (actual time=0.003..0.003 rows=1 loops=343)

  • Index Cond: (m_date = tl.m_date)
  • Filter: ((platform_handle = 437) AND (sensor_id = tl.sensor_id))
  • Rows Removed by Filter: 3