explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5QvQ

Settings
# exclusive inclusive rows x rows loops node
1. 2,040.734 64,303.646 ↓ 285.0 285 1

HashSetOp Intersect (cost=0.70..1,543.06 rows=1 width=20) (actual time=64,139.852..64,303.646 rows=285 loops=1)

  • Buffers: shared read=1232157
2. 204.501 62,262.912 ↓ 7,597.2 3,000,891 1

Append (cost=0.70..1,542.08 rows=395 width=20) (actual time=35.079..62,262.912 rows=3,000,891 loops=1)

  • Buffers: shared read=1232157
3. 359.843 56,159.095 ↓ 3,000,000.0 3,000,000 1

Subquery Scan on *SELECT* 2 (cost=0.70..8.54 rows=1 width=20) (actual time=35.078..56,159.095 rows=3,000,000 loops=1)

  • Buffers: shared read=1231257
4. 55,799.252 55,799.252 ↓ 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=35.067..55,799.252 rows=3,000,000 loops=1)

  • Index Cond: ((detail_type = 'BacNetProperty'::text) AND (name = 'BACnet Property 6'::text) AND (value = 'BACnet Property 6 value'::text))
  • Buffers: shared read=1231257
5. 0.866 5,899.316 ↓ 2.3 891 1

Subquery Scan on *SELECT* 1 (cost=0.70..1,531.56 rows=394 width=20) (actual time=46.476..5,899.316 rows=891 loops=1)

  • Buffers: shared read=900
6. 5,898.450 5,898.450 ↓ 2.3 891 1

Index Scan using entity_detail_detail_type_name_value_idx on entity_detail entity_detail_1 (cost=0.70..1,527.62 rows=394 width=16) (actual time=46.475..5,898.450 rows=891 loops=1)

  • Index Cond: ((detail_type = 'Tag'::text) AND (name = 'Tag1'::text) AND (value = 'tag 2494'::text))
  • Buffers: shared read=900