explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CfyX

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 14,131.742 ↓ 25.0 100 1

Limit (cost=53.74..53.75 rows=4 width=67) (actual time=14,131.699..14,131.742 rows=100 loops=1)

  • Buffers: shared hit=367877 read=133361
2. 82.221 14,131.713 ↓ 25.0 100 1

Sort (cost=53.74..53.75 rows=4 width=67) (actual time=14,131.697..14,131.713 rows=100 loops=1)

  • Sort Key: e.id
  • Sort Method: top-N heapsort Memory: 49kB
  • Buffers: shared hit=367877 read=133361
3. 208.245 14,049.492 ↓ 25,000.0 100,000 1

Nested Loop (cost=1.13..53.70 rows=4 width=67) (actual time=2.297..14,049.492 rows=100,000 loops=1)

  • Buffers: shared hit=367874 read=133361
4. 1,441.247 1,441.247 ↓ 25,000.0 100,000 1

Index Scan using entity_detail_detail_type_name_value_idx on entity_detail ed (cost=0.70..19.89 rows=4 width=16) (actual time=0.142..1,441.247 rows=100,000 loops=1)

  • Index Cond: ((detail_type = 'Parameter'::detail_type) AND (name = 'Device Parameter 2'::text) AND (value = 'Device Parameter 2 value'::text))
  • Buffers: shared hit=2 read=100822
5. 12,400.000 12,400.000 ↑ 1.0 1 100,000

Index Scan using entity_pkey on entity e (cost=0.44..8.45 rows=1 width=67) (actual time=0.124..0.124 rows=1 loops=100,000)

  • Index Cond: (id = ed.entity_id)
  • Buffers: shared hit=367872 read=32539