explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ABgv

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 0.104 ↑ 35.5 4 1

Hash Semi Join (cost=5.34..13.67 rows=142 width=59) (actual time=0.087..0.104 rows=4 loops=1)

  • Output: xa.deduction_id, xa.attribute_id, xa.boolean_value, xa.integer_value, xa.numeric_value, xa.date_value, xa.timestamp_value, xa.varchar_value, xa.list_value
  • Hash Cond: (xa.deduction_id = unnest.unnest)
  • Buffers: shared hit=5
2. 0.030 0.074 ↑ 2.8 50 1

Hash Join (cost=3.09..9.46 rows=142 width=59) (actual time=0.040..0.074 rows=50 loops=1)

  • Output: xa.deduction_id, xa.attribute_id, xa.boolean_value, xa.integer_value, xa.numeric_value, xa.date_value, xa.timestamp_value, xa.varchar_value, xa.list_value
  • Inner Unique: true
  • Hash Cond: (xa.attribute_id = att.attribute_id)
  • Buffers: shared hit=5
3. 0.020 0.020 ↑ 2.4 111 1

Seq Scan on client_demo.deduction_attribute xa (cost=0.00..5.64 rows=264 width=59) (actual time=0.008..0.020 rows=111 loops=1)

  • Output: xa.deduction_id, xa.attribute_id, xa.boolean_value, xa.integer_value, xa.numeric_value, xa.date_value, xa.timestamp_value, xa.varchar_value, xa.list_value
  • Buffers: shared hit=3
4. 0.007 0.024 ↑ 1.0 35 1

Hash (cost=2.65..2.65 rows=35 width=16) (actual time=0.024..0.024 rows=35 loops=1)

  • Output: att.attribute_id
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=2
5. 0.017 0.017 ↑ 1.0 35 1

Seq Scan on client_demo.attribute att (cost=0.00..2.65 rows=35 width=16) (actual time=0.004..0.017 rows=35 loops=1)

  • Output: att.attribute_id
  • Filter: att.active_ind
  • Rows Removed by Filter: 30
  • Buffers: shared hit=2
6. 0.002 0.010 ↑ 50.0 2 1

Hash (cost=1.00..1.00 rows=100 width=16) (actual time=0.010..0.010 rows=2 loops=1)

  • Output: unnest.unnest
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.008 0.008 ↑ 50.0 2 1

Function Scan on pg_catalog.unnest (cost=0.00..1.00 rows=100 width=16) (actual time=0.007..0.008 rows=2 loops=1)

  • Output: unnest.unnest
  • Function Call: unnest('{08d813ca-bff2-4297-97ce-f03a60b60264,0ce6625e-6e59-4c39-b284-7d5c87d5868d}'::uuid[])
Planning time : 0.358 ms
Execution time : 0.160 ms