explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UZol

Settings
# exclusive inclusive rows x rows loops node
1. 45.239 87.602 ↓ 1.0 200,000 1

Hash Join (cost=8.10..293,001.48 rows=193,897 width=30) (actual time=0.925..87.602 rows=200,000 loops=1)

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

Initplan (forHash Join)

3. 0.246 0.246 ↑ 1.0 1 1

Seq Scan on n_brand (cost=0.00..1.04 rows=1 width=4) (actual time=0.245..0.246 rows=1 loops=1)

  • Filter: (name = 'blk-id'::text)
  • Rows Removed by Filter: 2
4. 42.056 42.056 ↓ 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.839..42.056 rows=200,000 loops=1)

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

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

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

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

Planning time : 2.260 ms
Execution time : 93.879 ms