explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vo3iC

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.004 0.441 ↑ 8.0 1 1

Unique (cost=53.09..53.13 rows=8 width=14) (actual time=0.438..0.441 rows=1 loops=1)

2. 0.008 0.437 ↑ 8.0 1 1

Sort (cost=53.09..53.11 rows=8 width=14) (actual time=0.435..0.437 rows=1 loops=1)

  • Sort Key: system_code_detail.system_code_value_desc
  • Sort Method: quicksort Memory: 25kB
3. 0.173 0.429 ↑ 8.0 1 1

Hash Semi Join (cost=8.58..52.97 rows=8 width=14) (actual time=0.422..0.429 rows=1 loops=1)

  • Hash Cond: ((system_code_detail.system_code_value)::text = (unnest(string_to_array($0, ','::text))))
4. 0.178 0.224 ↓ 2.2 225 1

Bitmap Heap Scan on system_code_detail (cost=5.76..49.80 rows=102 width=18) (actual time=0.051..0.224 rows=225 loops=1)

  • Recheck Cond: (((system_code_id)::text = '200'::text) AND ((system_code_type)::text = '04'::text) AND (eff_end_ts > now()))
  • Heap Blocks: exact=7
5. 0.046 0.046 ↓ 2.2 225 1

Bitmap Index Scan on system_code_detail_pkey (cost=0.00..5.73 rows=102 width=0) (actual time=0.045..0.046 rows=225 loops=1)

  • Index Cond: (((system_code_id)::text = '200'::text) AND ((system_code_type)::text = '04'::text) AND (eff_end_ts > now()))
6. 0.004 0.032 ↑ 100.0 1 1

Hash (cost=1.57..1.57 rows=100 width=32) (actual time=0.031..0.032 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.011 0.028 ↑ 100.0 1 1

ProjectSet (cost=0.05..0.57 rows=100 width=32) (actual time=0.024..0.028 rows=1 loops=1)

8.          

Initplan (forProjectSet)

9. 0.004 0.014 ↑ 1.0 1 1

Limit (cost=0.00..0.05 rows=1 width=2) (actual time=0.011..0.014 rows=1 loops=1)

10. 0.010 0.010 ↑ 5,120.0 1 1

Seq Scan on provider (cost=0.00..242.20 rows=5,120 width=2) (actual time=0.009..0.010 rows=1 loops=1)

11. 0.003 0.003 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.003 rows=1 loops=1)