explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YEMV

Settings
# exclusive inclusive rows x rows loops node
1. 45.507 82.088 ↓ 1.0 200,000 1

Hash Join (cost=32.94..293,026.32 rows=193,897 width=30) (actual time=0.096..82.088 rows=200,000 loops=1)

  • Hash Cond: (nav.attr_id = na.attr_id)
2.          

Initplan (forHash Join)

3. 0.006 0.006 ↑ 6.0 1 1

Seq Scan on n_brand (cost=0.00..25.88 rows=6 width=4) (actual time=0.005..0.006 rows=1 loops=1)

  • Filter: (name = 'blk-id'::text)
  • Rows Removed by Filter: 2
4. 36.525 36.525 ↓ 1.0 200,000 1

Index Scan using n_nextapp_attr_val_pkey on n_nextapp_attr_val nav (cost=0.56..292,474.18 rows=193,897 width=26) (actual time=0.031..36.525 rows=200,000 loops=1)

  • Index Cond: ((brand_id = $0) AND (pid > 100000) AND (pid <= 101000))
5. 0.026 0.050 ↑ 1.0 200 1

Hash (cost=4.00..4.00 rows=200 width=8) (actual time=0.050..0.050 rows=200 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
6. 0.024 0.024 ↑ 1.0 200 1

Seq Scan on n_nextapp_attr na (cost=0.00..4.00 rows=200 width=8) (actual time=0.004..0.024 rows=200 loops=1)

Planning time : 0.496 ms
Execution time : 88.414 ms