explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gDG6

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.006 0.015 ↑ 43.3 6 1

Result (cost=0.00..27.15 rows=260 width=32) (actual time=0.008..0.015 rows=6 loops=1)

2. 0.001 0.009 ↑ 43.3 6 1

Append (cost=0.00..23.90 rows=260 width=32) (actual time=0.005..0.009 rows=6 loops=1)

3. 0.006 0.006 ↑ 32.5 4 1

Seq Scan on _hyper_2_1_chunk (cost=0.00..11.30 rows=130 width=32) (actual time=0.005..0.006 rows=4 loops=1)

4. 0.002 0.002 ↑ 65.0 2 1

Seq Scan on _hyper_2_2_chunk (cost=0.00..11.30 rows=130 width=32) (actual time=0.002..0.002 rows=2 loops=1)

Planning time : 0.109 ms
Execution time : 0.030 ms