explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KRuG : check

Settings
# exclusive inclusive rows x rows loops node
1. 1,687.367 9,149.985 ↑ 1,512.0 1 1

GroupAggregate (cost=100,174.65..7,675,622.55 rows=1,512 width=18) (actual time=9,149.983..9,149.985 rows=1 loops=1)

  • Group Key: "PC0".companynum
2. 3,834.658 7,462.618 ↑ 130.7 2,845,510 1

Merge Right Join (cost=100,174.65..5,815,799.37 rows=371,961,612 width=19) (actual time=335.552..7,462.618 rows=2,845,510 loops=1)

  • Merge Cond: (("HJGROUP".hjwaribikigrcd)::text = ("PC0".hjwaribikigrcd)::text)
3. 1,864.378 1,864.378 ↑ 1.0 1,191,873 1

Index Only Scan using idx_qr001_hjcode_null on pr_kddi_hjfront_data_qr001 "HJGROUP" (cost=0.43..132,537.37 rows=1,208,430 width=9) (actual time=0.063..1,864.378 rows=1,191,873 loops=1)

  • Heap Fetches: 1,191,873
4. 1,467.263 1,763.582 ↓ 10.9 2,845,510 1

Materialize (cost=100,174.22..101,480.90 rows=261,336 width=28) (actual time=295.025..1,763.582 rows=2,845,510 loops=1)

5. 3.796 296.319 ↑ 129.6 2,017 1

Sort (cost=100,174.22..100,827.56 rows=261,336 width=28) (actual time=295.021..296.319 rows=2,017 loops=1)

  • Sort Key: "PC0".hjwaribikigrcd USING ~<~
  • Sort Method: quicksort Memory: 206kB
6. 4.310 292.523 ↑ 129.6 2,017 1

Nested Loop Left Join (cost=0.42..70,405.30 rows=261,336 width=28) (actual time=3.782..292.523 rows=2,017 loops=1)

7. 281.908 281.908 ↑ 1.3 1,261 1

Seq Scan on pr_kddi_hjfront_data_qr001 "PC0" (cost=0.00..40,491.96 rows=1,588 width=39) (actual time=3.742..281.908 rows=1,261 loops=1)

  • Filter: ((companynum)::text = '01496133D'::text)
  • Rows Removed by Filter: 1,322,176
8. 6.305 6.305 ↑ 5.0 1 1,261

Index Only Scan using idx_qr001_hjcode_notnull on pr_kddi_hjfront_data_qr001 "ACCOUNT" (cost=0.42..18.79 rows=5 width=11) (actual time=0.004..0.005 rows=1 loops=1,261)

  • Index Cond: (togoseikyusakiacc = ("PC0".togoseikyusakiacc)::text)
  • Heap Fetches: 765