explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sVAl

Settings
# exclusive inclusive rows x rows loops node
1. 0.058 57,487.044 ↓ 10.0 10 1

Nested Loop (cost=8.99..17.02 rows=1 width=69) (actual time=57,406.709..57,487.044 rows=10 loops=1)

  • Buffers: shared hit=30 read=1231269
2. 10.804 57,397.716 ↓ 10.0 10 1

HashAggregate (cost=8.56..8.57 rows=1 width=16) (actual time=57,397.698..57,397.716 rows=10 loops=1)

  • Group Key: entity_detail.entity_id
  • Buffers: shared hit=3 read=1231256
3. 0.021 57,386.912 ↓ 10.0 10 1

Limit (cost=8.54..8.54 rows=1 width=16) (actual time=57,386.891..57,386.912 rows=10 loops=1)

  • Buffers: shared hit=3 read=1231256
4. 563.505 57,386.891 ↓ 10.0 10 1

Sort (cost=8.54..8.54 rows=1 width=16) (actual time=57,386.890..57,386.891 rows=10 loops=1)

  • Sort Key: entity_detail.entity_id
  • Sort Method: top-N heapsort Memory: 25kB
  • Buffers: shared hit=3 read=1231256
5. 56,823.386 56,823.386 ↓ 3,000,000.0 3,000,000 1

Index Scan using entity_detail_detail_type_name_value_idx on entity_detail (cost=0.70..8.53 rows=1 width=16) (actual time=58.791..56,823.386 rows=3,000,000 loops=1)

  • Index Cond: ((detail_type = 'BacNetProperty'::text) AND (name = 'BACnet Property 1'::text) AND (value = 'BACnet Property 1 value'::text))
  • Buffers: shared read=1231256
6. 89.270 89.270 ↑ 1.0 1 10

Index Scan using entity_pkey on entity (cost=0.43..8.45 rows=1 width=69) (actual time=8.927..8.927 rows=1 loops=10)

  • Index Cond: (id = entity_detail.entity_id)
  • Buffers: shared hit=27 read=13