explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Uqro

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.310 ↑ 2.8 50 1

Hash Semi Join (cost=19.21..27.54 rows=142 width=59) (actual time=0.260..0.310 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
  • Hash Cond: (xa.deduction_id = unnest.unnest)
  • Buffers: shared hit=68
2.          

Initplan (forHash Semi Join)

3. 0.042 0.135 ↑ 1.0 1 1

Aggregate (cost=13.86..13.87 rows=1 width=32) (actual time=0.134..0.135 rows=1 loops=1)

  • Output: array_agg(deduction.deduction_id)
  • Buffers: shared hit=63
4. 0.093 0.093 ↑ 1.0 98 1

Index Only Scan using deduction_pkey on client_demo.deduction (cost=0.14..13.61 rows=98 width=16) (actual time=0.031..0.093 rows=98 loops=1)

  • Output: deduction.deduction_id
  • Heap Fetches: 84
  • Buffers: shared hit=63
5. 0.033 0.079 ↑ 2.8 50 1

Hash Join (cost=3.09..9.46 rows=142 width=59) (actual time=0.043..0.079 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
6. 0.021 0.021 ↑ 2.4 111 1

Seq Scan on client_demo.deduction_attribute xa (cost=0.00..5.64 rows=264 width=59) (actual time=0.009..0.021 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
7. 0.008 0.025 ↑ 1.0 35 1

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

  • Output: att.attribute_id
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=2
8. 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.003..0.017 rows=35 loops=1)

  • Output: att.attribute_id
  • Filter: att.active_ind
  • Rows Removed by Filter: 30
  • Buffers: shared hit=2
9. 0.031 0.207 ↑ 1.0 98 1

Hash (cost=1.00..1.00 rows=100 width=16) (actual time=0.207..0.207 rows=98 loops=1)

  • Output: unnest.unnest
  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
  • Buffers: shared hit=63
10. 0.176 0.176 ↑ 1.0 98 1

Function Scan on pg_catalog.unnest (cost=0.00..1.00 rows=100 width=16) (actual time=0.165..0.176 rows=98 loops=1)

  • Output: unnest.unnest
  • Function Call: unnest($0)
  • Buffers: shared hit=63
Planning time : 0.417 ms
Execution time : 0.409 ms