explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dRZD

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 664.584 ↑ 1.0 1 1

Limit (cost=0.44..2,219.94 rows=1 width=8) (actual time=664.582..664.584 rows=1 loops=1)

2. 4.413 664.581 ↑ 32,010.0 1 1

Nested Loop (cost=0.44..71,046,350.76 rows=32,010 width=8) (actual time=664.581..664.581 rows=1 loops=1)

3. 61.848 61.848 ↑ 1,062.1 6,648 1

Seq Scan on producttable (cost=0.00..22,761,384.54 rows=7,060,936 width=16) (actual time=0.067..61.848 rows=6,648 loops=1)

  • Filter: (parentproductid IS NULL)
  • Rows Removed by Filter: 205617
4. 598.320 598.320 ↓ 0.0 0 6,648

Index Scan using productcategorytable_pkey on productcategorytable (cost=0.44..6.84 rows=1 width=8) (actual time=0.090..0.090 rows=0 loops=6,648)

  • Index Cond: (productcategoryid = producttable.productcategoryid)
  • Filter: (masterproductcategoryid = 491)
  • Rows Removed by Filter: 1
Planning time : 0.347 ms
Execution time : 664.609 ms