explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L0q0

Settings
# exclusive inclusive rows x rows loops node
1. 0.090 0.954 ↑ 1.0 1,000 1

Limit (cost=7.54..79.06 rows=1,000 width=8) (actual time=0.109..0.954 rows=1,000 loops=1)

  • Buffers: shared hit=21 read=6
2.          

Initplan (forLimit)

3. 0.004 0.004 ↑ 1.0 1 1

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

  • Filter: (name = 'blk-id'::text)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=1
4. 0.263 0.860 ↑ 19,201.5 1,000 1

Hash Join (cost=6.50..1,373,411.31 rows=19,201,548 width=8) (actual time=0.108..0.860 rows=1,000 loops=1)

  • Hash Cond: (nav.attr_id = na.attr_id)
  • Buffers: shared hit=21 read=6
5. 0.512 0.512 ↑ 19,201.5 1,000 1

Seq Scan on m_nextapp_attr_val nav (cost=0.00..1,321,932.66 rows=19,201,548 width=4) (actual time=0.017..0.512 rows=1,000 loops=1)

  • Filter: ((pid > 100000) AND (brand_id = $0))
  • Rows Removed by Filter: 1928
  • Buffers: shared hit=19 read=6
6. 0.044 0.085 ↑ 1.0 200 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
  • Buffers: shared hit=2
7. 0.041 0.041 ↑ 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.041 rows=200 loops=1)

  • Buffers: shared hit=2
Planning time : 0.258 ms
Execution time : 1.038 ms