explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bzIh

Settings
# exclusive inclusive rows x rows loops node
1. 113.904 23,362.464 ↓ 1.4 140,499 1

Hash Left Join (cost=70,708.49..675,531.65 rows=103,844 width=221) (actual time=20,710.870..23,362.464 rows=140,499 loops=1)

  • Hash Cond: (NULLIF((vial.hstore_fields ->> 'vial.field_296'::text), ''::text) = (lkup0.code)::text)
2. 2,102.538 23,248.519 ↓ 1.4 140,499 1

Hash Join (cost=70,707.48..675,011.42 rows=103,844 width=75) (actual time=20,710.811..23,248.519 rows=140,499 loops=1)

  • Hash Cond: ((vial.sample_id)::text = (sample.sample_id)::text)
3. 18,777.419 18,777.419 ↓ 1.4 140,499 1

Seq Scan on vial (cost=0.00..586,457.91 rows=103,844 width=75) (actual time=18,335.651..18,777.419 rows=140,499 loops=1)

  • Filter: (NULLIF((hstore_fields ->> 'vial.field_296'::text), ''::text) = '2'::text)
  • Rows Removed by Filter: 20628394
4. 1,310.927 2,368.562 ↑ 1.0 3,865,247 1

Hash (cost=42,080.12..42,080.12 rows=3,865,247 width=8) (actual time=2,368.561..2,368.562 rows=3,865,247 loops=1)

  • Buckets: 1048576 Batches: 8 Memory Usage: 27291kB
5. 1,057.635 1,057.635 ↑ 1.0 3,865,247 1

Seq Scan on sample (cost=0.00..42,080.12 rows=3,865,247 width=8) (actual time=0.025..1,057.635 rows=3,865,247 loops=1)

6. 0.021 0.041 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=256) (actual time=0.041..0.041 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.020 0.020 ↑ 1.0 1 1

Seq Scan on lkup_concentration_unit lkup0 (cost=0.00..1.01 rows=1 width=256) (actual time=0.019..0.020 rows=1 loops=1)

  • Filter: ((code)::text = '2'::text)
  • Rows Removed by Filter: 1
Planning time : 134.493 ms