explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.257 0.529 ↑ 1.6 500 1

Aggregate (cost=83.33..91.45 rows=812 width=42) (actual time=0.453..0.529 rows=500 loops=1)

2. 0.064 0.272 ↑ 1.0 812 1

Append (cost=0..81.3 rows=812 width=42) (actual time=0.028..0.272 rows=812 loops=1)

3. 0.079 0.079 ↑ 1.0 312 1

Seq Scan on temp_dat_08082019064545_71670 temp_dat_08082019064545_71670 (cost=0..41.12 rows=312 width=13) (actual time=0.027..0.079 rows=312 loops=1)

4. 0.129 0.129 ↑ 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.011..0.129 rows=500 loops=1)

Planning time : 0.069 ms
Execution time : 1.405 ms