explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ctiG

Settings
# exclusive inclusive rows x rows loops node
1. 1,471.129 3,898.123 ↓ 0.0 0 1

Update on all_products_indexed_v2 (cost=231.30..1,076,431.54 rows=3,177,106 width=917) (actual time=3,898.123..3,898.123 rows=0 loops=1)

2. 385.155 2,426.994 ↑ 276.8 11,480 1

Hash Join (cost=231.30..1,076,431.54 rows=3,177,106 width=917) (actual time=1,552.557..2,426.994 rows=11,480 loops=1)

  • Hash Cond: (all_products_indexed_v2._id = __todo_ids._id)
3. 2,034.084 2,034.084 ↑ 1.3 4,884,367 1

Seq Scan on all_products_indexed_v2 (cost=0.00..1,024,175.13 rows=6,354,213 width=911) (actual time=0.049..2,034.084 rows=4,884,367 loops=1)

4. 1.015 7.755 ↓ 49.1 9,818 1

Hash (cost=228.80..228.80 rows=200 width=38) (actual time=7.755..7.755 rows=9,818 loops=1)

  • Buckets: 16384 (originally 1024) Batches: 1 (originally 1) Memory Usage: 809kB
5. 4.818 6.740 ↓ 49.1 9,818 1

HashAggregate (cost=226.80..228.80 rows=200 width=38) (actual time=5.972..6.740 rows=9,818 loops=1)

  • Group Key: __todo_ids._id
6. 1.922 1.922 ↑ 1.1 10,000 1

Seq Scan on __todo_ids (cost=0.00..198.24 rows=11,424 width=38) (actual time=0.029..1.922 rows=10,000 loops=1)