explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WR9k

Settings
# exclusive inclusive rows x rows loops node
1. 11,934.221 17,025.563 ↓ 0.0 0 1

Insert on foo (cost=364,916.58..468,375.71 rows=1,000,113 width=45) (actual time=17,025.559..17,025.563 rows=0 loops=1)

2.          

CTE updateexp

3. 24,889.848 57,877.577 ↓ 0.0 0 1

Update on foo foo_1 (cost=120,844.54..364,916.58 rows=1,000,113 width=57) (actual time=57,877.577..57,877.577 rows=0 loops=1)

4. 15,902.974 32,987.729 ↑ 1.0 1,000,000 1

Hash Join (cost=120,844.54..364,916.58 rows=1,000,113 width=57) (actual time=9,400.062..32,987.729 rows=1,000,000 loops=1)

  • Hash Cond: (foo_1.id = s.id)
5. 7,710.310 7,710.310 ↑ 1.0 1,000,000 1

Seq Scan on foo foo_1 (cost=0.00..207,647.84 rows=1,009,884 width=47) (actual time=0.848..7,710.310 rows=1,000,000 loops=1)

6. 4,569.386 9,374.445 ↑ 1.0 1,000,000 1

Hash (cost=103,459.13..103,459.13 rows=1,000,113 width=14) (actual time=9,374.445..9,374.445 rows=1,000,000 loops=1)

  • Buckets: 131,072 Batches: 16 Memory Usage: 3,961kB
7. 4,805.059 4,805.059 ↑ 1.0 1,000,000 1

Seq Scan on source s (cost=0.00..103,459.13 rows=1,000,113 width=14) (actual time=0.026..4,805.059 rows=1,000,000 loops=1)

8. 5,091.342 5,091.342 ↑ 1.0 1,000,000 1

Seq Scan on source (cost=0.00..103,459.13 rows=1,000,113 width=45) (actual time=0.017..5,091.342 rows=1,000,000 loops=1)