explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bUDn

Settings
# exclusive inclusive rows x rows loops node
1. 0.046 5,015.350 ↑ 24.4 40 1

Unique (cost=452,420.61..452,425.50 rows=977 width=10) (actual time=5,015.282..5,015.350 rows=40 loops=1)

2. 0.270 5,015.304 ↑ 24.4 40 1

Sort (cost=452,420.61..452,423.06 rows=977 width=10) (actual time=5,015.280..5,015.304 rows=40 loops=1)

  • Sort Key: company_number
  • Sort Method: quicksort Memory: 26kB
3. 5,015.034 5,015.034 ↑ 24.4 40 1

Seq Scan on pr_kddi_hjfront_data_mac_11a33 "PC0" (cost=0.00..452,372.09 rows=977 width=10) (actual time=27.797..5,015.034 rows=40 loops=1)

  • Filter: (((kanji_business_corp_before)::text ~~ '%日立製作所%'::text) OR ((kanji_business_corp)::text ~~ '%日立製作所%'::text))
  • Rows Removed by Filter: 4,931,433