explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6ErR

Settings
# exclusive inclusive rows x rows loops node
1. 174.782 279.539 ↓ 0.0 0 1

Nested Loop (cost=0.00..19,189,801.01 rows=1,533,481,200 width=156) (actual time=279.539..279.539 rows=0 loops=1)

2. 104.757 104.757 ↑ 1.0 1,255,506 1

Seq Scan on pgbench_history (cost=0.00..21,261.01 rows=1,277,901 width=116) (actual time=0.015..104.757 rows=1,255,506 loops=1)

3. 0.000 0.000 ↓ 0.0 0 1,255,506

Materialize (cost=0.00..28.00 rows=1,200 width=40) (actual time=0.000..0.000 rows=0 loops=1,255,506)

4. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on tablename (cost=0.00..22.00 rows=1,200 width=40) (actual time=0.007..0.007 rows=0 loops=1)

Planning time : 0.086 ms
Execution time : 279.569 ms