explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ro9I

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 35,444.859 ↑ 926.3 19 1

Result (cost=0.00..2,708,718.94 rows=17,600 width=149) (actual time=14,724.148..35,444.859 rows=19 loops=1)

2. 35,439.737 35,439.737 ↑ 926.3 19 1

ProjectSet (cost=0.00..2,694,242.94 rows=17,600 width=990) (actual time=14,723.425..35,439.737 rows=19 loops=1)

3. 35,439.645 35,439.645 ↑ 11.0 16 1

Seq Scan on import_vn.observations_json new (cost=0.00..2,694,152.30 rows=176 width=958) (actual time=14,723.399..35,439.645 rows=16 loops=1)

Planning time : 0.188 ms
Execution time : 35,444.914 ms