explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dm1p : Optimization for: Optimization for: JSON; plan #L8y; plan #3dai

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.063 0.269 ↑ 1.0 812 1

Append (cost=0..72.18 rows=812 width=13) (actual time=0.04..0.269 rows=812 loops=1)

2. 0.104 0.104 ↑ 1.0 312 1

Seq Scan on temp_dat_08082019064545_71670 temp_dat_08082019064545_71670 (cost=0..40.12 rows=312 width=13) (actual time=0.039..0.104 rows=312 loops=1)

3. 0.102 0.102 ↑ 1.0 500 1

Seq Scan on temp_opt_08082019065158_71670 temp_opt_08082019065158_71670 (cost=0..28 rows=500 width=13) (actual time=0.004..0.102 rows=500 loops=1)

Planning time : 0.069 ms
Execution time : 0.317 ms