explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i5yC

Settings
# exclusive inclusive rows x rows loops node
1. 36.496 22,592.697 ↓ 0.0 1 1

Aggregate (cost=0..0 rows=0 width=0) (actual time=22,592.697..22,592.697 rows=1 loops=1)

  • Output: count(*)
2. 1,458.639 22,556.201 ↓ 0.0 101,002 1

Nested Loop (cost=0..0 rows=0 width=0) (actual time=6.919..22,556.201 rows=101,002 loops=1)

  • Inner Unique: true
3. 89.146 89.146 ↓ 0.0 101,002 1

Foreign Scan on public.products p1 (cost=0..0 rows=0 width=0) (actual time=6.453..89.146 rows=101,002 loops=1)

  • Output: p1.id, p1.created_at, p1.category, p1.ean, p1.price, p1.quantity, p1.rating, p1.title, p1.vendor
4. 21,008.416 21,008.416 ↓ 0.0 1 101,002

Index Scan using products_pkey on public.products p2 (cost=0..0 rows=0 width=0) (actual time=0.208..0.208 rows=1 loops=101,002)

  • Output: p2.id, p2.created_at, p2.category, p2.ean, p2.price, p2.quantity, p2.rating, p2.title, p2.vendor
  • Index Cond: (p2.id = p1.id)
Planning time : 6.447 ms
Execution time : 22,983.449 ms