#	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

EXPLAIN ANALYZE INSERT INTO all_stations
                        ("platform_handle", "sensor_id", "m_type_id",
                         "m_date", "m_lon", "m_lat", "m_z", "m_value",
                         "m_value_2", "m_value_3")
                        SELECT 437, "sensor_id", "m_type_id",
                         "m_date", "m_lon", "m_lat", "m_z", "m_value",
                         "m_value_2", "m_value_3" FROM temp_table_2 tl
                        WHERE NOT EXISTS (SELECT FROM all_stations t
                                 WHERE t.platform_handle = 437
                                   AND t.sensor_id = tl.sensor_id
                                   AND t.m_date = tl.m_date)

Insert on all_stations  (cost=10000000000.43..10000003780.11 rows=257 width=264) (actual time=1.108..1.108 rows=0 loops=1)
  ->  Nested Loop Anti Join  (cost=10000000000.43..10000003780.11 rows=257 width=264) (actual time=1.107..1.107 rows=0 loops=1)
        ->  Seq Scan on temp_table_2 tl  (cost=10000000000.00..10000000007.43 rows=343 width=64) (actual time=0.007..0.036 rows=343 loops=1)
        ->  Append  (cost=0.43..14.45 rows=4 width=12) (actual time=0.003..0.003 rows=1 loops=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

Per node type stats

node type	count	sum of times	% of query
Append	1	0.000 ms	0.0 %
Index Scan	1	1.029 ms	92.9 %
Insert	1	0.001 ms	0.1 %
Nested Loop Anti Join	1	0.042 ms	3.8 %
Seq Scan	1	0.036 ms	3.2 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
all_stations	1	0.001 ms	0.1 %
Insert	1	0.001 ms	100.0 %
glos_45176	1	1.029 ms	92.9 %
Index Scan	1	1.029 ms	100.0 %
temp_table_2	1	0.036 ms	3.2 %
Seq Scan	1	0.036 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZFX

Color mode:

Visible columns:

Per node type stats

Per table stats