explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N1U

Settings
# exclusive inclusive rows x rows loops node
1. 46.516 112.819 ↑ 3.6 192,000 1

Hash Join (cost=8.10..709,578.27 rows=683,232 width=50) (actual time=0.686..112.819 rows=192,000 loops=1)

  • Hash Cond: (value.attr_id = field.attr_id)
  • Buffers: shared hit=7374
2.          

Initplan (forHash Join)

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. 33.376 66.237 ↑ 3.6 192,000 1

Nested Loop (cost=0.56..707,739.25 rows=683,232 width=42) (actual time=0.620..66.237 rows=192,000 loops=1)

  • Buffers: shared hit=7372
5. 0.086 0.861 ↑ 1.0 1,000 1

Limit (cost=0.00..24.00 rows=1,000 width=4) (actual time=0.600..0.861 rows=1,000 loops=1)

  • Buffers: shared hit=94
6. 0.775 0.775 ↑ 91.1 1,000 1

Seq Scan on product_entity (cost=0.00..2,185.00 rows=91,053 width=4) (actual time=0.599..0.775 rows=1,000 loops=1)

  • Filter: (pid > 109000)
  • Rows Removed by Filter: 9000
  • Buffers: shared hit=94
7. 32.000 32.000 ↑ 3.6 192 1,000

Index Scan using m_nextapp_attr_val_pkey on m_nextapp_attr_val value (cost=0.56..700.88 rows=683 width=46) (actual time=0.005..0.032 rows=192 loops=1,000)

  • Index Cond: ((pid = product_entity.pid) AND (brand_id = $0))
  • Buffers: shared hit=7277
8. 0.032 0.062 ↑ 1.0 200 1

Hash (cost=4.00..4.00 rows=200 width=16) (actual time=0.062..0.062 rows=200 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
  • Buffers: shared hit=2
9. 0.030 0.030 ↑ 1.0 200 1

Seq Scan on n_nextapp_attr field (cost=0.00..4.00 rows=200 width=16) (actual time=0.004..0.030 rows=200 loops=1)

  • Buffers: shared hit=2
Planning time : 0.286 ms
Execution time : 120.146 ms