explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L8y : JSON

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.296 1.075 ↓ 2.5 500 1

Aggregate (cost=74.21..76.21 rows=200 width=13) (actual time=1.012..1.075 rows=500 loops=1)

2. 0.068 0.779 ↑ 1.0 812 1

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

3. 0.414 0.414 ↑ 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.268..0.414 rows=312 loops=1)

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