explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LVCm

Settings
# exclusive inclusive rows x rows loops node
1. 41.699 7,449.728 ↓ 50,000.0 100,000 1

Nested Loop (cost=13.00..29.50 rows=2 width=45) (actual time=5,680.693..7,449.728 rows=100,000 loops=1)

  • Buffers: shared hit=367941 read=133396
2. 20.792 5,708.029 ↓ 50,000.0 100,000 1

Unique (cost=12.56..12.57 rows=2 width=16) (actual time=5,666.389..5,708.029 rows=100,000 loops=1)

  • Buffers: shared hit=3 read=100940
3. 84.954 5,687.237 ↓ 50,000.0 100,000 1

Sort (cost=12.56..12.57 rows=2 width=16) (actual time=5,666.386..5,687.237 rows=100,000 loops=1)

  • Sort Key: entity_detail.entity_id
  • Sort Method: quicksort Memory: 7760kB
  • Buffers: shared hit=3 read=100940
4. 5,602.283 5,602.283 ↓ 50,000.0 100,000 1

Index Scan using entity_detail_detail_type_name_value_idx on entity_detail (cost=0.70..12.55 rows=2 width=16) (actual time=54.804..5,602.283 rows=100,000 loops=1)

  • Index Cond: ((detail_type = 'Parameter'::text) AND (name = 'Device Parameter 1'::text) AND (value = 'Device Parameter 1 value'::text))
  • Buffers: shared read=100940
5. 1,700.000 1,700.000 ↑ 1.0 1 100,000

Index Scan using entity_pkey on entity e (cost=0.43..8.45 rows=1 width=45) (actual time=0.017..0.017 rows=1 loops=100,000)

  • Index Cond: (id = entity_detail.entity_id)
  • Buffers: shared hit=367938 read=32456