explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 65TU

Settings
# exclusive inclusive rows x rows loops node
1. 50.642 94.415 ↑ 1.0 192,000 1

Hash Join (cost=8.10..395,029.87 rows=192,588 width=46) (actual time=0.130..94.415 rows=192,000 loops=1)

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

Initplan (forHash Join)

3. 0.011 0.011 ↑ 1.0 1 1

Seq Scan on m_brand (cost=0.00..1.04 rows=1 width=4) (actual time=0.010..0.011 rows=1 loops=1)

  • Filter: (name = 'blk-id'::text)
  • Rows Removed by Filter: 2
4. 43.705 43.705 ↑ 1.0 192,000 1

Index Scan using m_nextapp_attr_val_pkey on m_nextapp_attr_val nav (cost=0.56..394,506.08 rows=192,588 width=42) (actual time=0.056..43.705 rows=192,000 loops=1)

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

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

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

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

Planning time : 0.544 ms
Execution time : 100.419 ms