explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OKDI

Settings
# exclusive inclusive rows x rows loops node
1. 138,799.645 186,048.745 ↓ 0.0 0 1

Insert on live_delivery (cost=0.00..1,511,465.77 rows=58,110,390 width=169) (actual time=186,048.745..186,048.745 rows=0 loops=1)

2. 21,236.762 47,249.100 ↑ 1.0 58,110,390 1

Nested Loop (cost=0.00..1,511,465.77 rows=58,110,390 width=169) (actual time=0.021..47,249.100 rows=58,110,390 loops=1)

3. 7,536.214 7,536.214 ↑ 1.0 298,002 1

Seq Scan on demo_groups d (cost=0.00..58,706.02 rows=298,002 width=1,218) (actual time=0.007..7,536.214 rows=298,002 loops=1)

4. 18,476.124 18,476.124 ↑ 1.0 195 298,002

Values Scan on "*VALUES*" (cost=0.00..2.44 rows=195 width=64) (actual time=0.000..0.062 rows=195 loops=298,002)