explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zof3

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

Insert on tbl_health (cost=4.30..4.31 rows=1 width=108) (actual time=0.162..0.163 rows=0 loops=1)

2.          

Initplan (for Insert)

3. 0.000 0.160 ↑ 2.0 1 1

Append (cost=0.00..8.60 rows=2 width=0) (actual time=0.160..0.160 rows=1 loops=1)

4. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on tbl_health tbl_health_1 (cost=0.00..0.00 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: ((station_id = '2032'::bigint) AND (parameter_id = 70) AND (datetime_read = '2020-09-13 21:12:06'::timestamp(0) without time zone))
5. 0.155 0.155 ↑ 1.0 1 1

Index Only Scan using tbl_health_2020_station_id_parameter_id_datetime_read_key on tbl_health_2020 (cost=0.57..8.59 rows=1 width=0) (actual time=0.154..0.155 rows=1 loops=1)

  • Index Cond: ((station_id = '2032'::bigint) AND (parameter_id = 70) AND (datetime_read = '2020-09-13 21:12:06'::timestamp(0) without time zone))
  • Heap Fetches: 1
6. 0.161 0.161 ↓ 0.0 0 1

Result (cost=0.00..0.01 rows=1 width=108) (actual time=0.161..0.161 rows=0 loops=1)

  • One-Time Filter: ($0 IS NOT TRUE)
Planning time : 6.436 ms
Execution time : 0.230 ms