explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qdBp

Settings
# exclusive inclusive rows x rows loops node
1. 0.121 33,280.453 ↑ 4.4 27 1

Sort (cost=3,570,221.32..3,570,221.62 rows=118 width=2,135) (actual time=33,280.434..33,280.453 rows=27 loops=1)

  • Sort Key: "PC0".hjwaribikigrcd, "PC0".tsushinwaribikigrcd, "PC0".togoseikyusakiacc, "PC0".onepaycd, "PC0".billingnm, "PC0".genrknplannm, "PC0".modelnm, "PC0".kanyushakanjinmnospace
  • Sort Method: quicksort Memory: 28kB
2. 10,236.995 33,280.332 ↑ 4.4 27 1

HashAggregate (cost=3,570,216.08..3,570,217.26 rows=118 width=2,135) (actual time=33,280.309..33,280.332 rows=27 loops=1)

  • Group Key: "PC0".hjwaribikigrcd, "PC0".tsushinwaribikigrcd, "PC0".togoseikyusakiacc, "PC0".onepaycd, "PC0".billingnm, "PC0".genrknplannm, "PC0".modelnm, "PC0".kanyushakanjinmnospace
3. 12,213.368 23,043.337 ↑ 9.3 9,256,132 1

Merge Right Join (cost=38,475.03..1,630,179.95 rows=86,223,828 width=2,136) (actual time=132.971..23,043.337 rows=9,256,132 loops=1)

  • Merge Cond: (("HJGROUPCODE".hjwaribikigrcd)::text = ("PC0".hjwaribikigrcd)::text)
4. 5,951.943 5,951.943 ↑ 1.0 2,380,917 1

Index Scan using idx_qr001_hjgroupcode_null on pr_kddi_hjfront_data_qr001 "HJGROUPCODE" (cost=0.43..292,160.40 rows=2,433,744 width=9) (actual time=0.031..5,951.943 rows=2,380,917 loops=1)

  • Filter: ((companynum)::text <> '01496133D'::text)
  • Rows Removed by Filter: 2,504
5. 4,830.299 4,878.026 ↓ 281.5 9,256,132 1

Materialize (cost=38,474.60..38,638.98 rows=32,876 width=2,136) (actual time=44.304..4,878.026 rows=9,256,132 loops=1)

6. 9.515 47.727 ↑ 6.3 5,222 1

Sort (cost=38,474.60..38,556.79 rows=32,876 width=2,136) (actual time=44.297..47.727 rows=5,222 loops=1)

  • Sort Key: "PC0".hjwaribikigrcd USING ~<~
  • Sort Method: quicksort Memory: 927kB
7. 8.671 38.212 ↑ 6.3 5,222 1

Nested Loop Left Join (cost=5.76..5,666.62 rows=32,876 width=2,136) (actual time=0.941..38.212 rows=5,222 loops=1)

8. 16.328 16.931 ↓ 21.4 2,522 1

Bitmap Heap Scan on pr_kddi_hjfront_data_qr001 "PC0" (cost=5.34..461.66 rows=118 width=2,136) (actual time=0.878..16.931 rows=2,522 loops=1)

  • Recheck Cond: ((companynum)::text = '01496133D'::text)
  • Heap Blocks: exact=1,725
9. 0.603 0.603 ↓ 21.4 2,522 1

Bitmap Index Scan on idx_qr001_comanynumber (cost=0.00..5.31 rows=118 width=0) (actual time=0.603..0.603 rows=2,522 loops=1)

  • Index Cond: ((companynum)::text = '01496133D'::text)
10. 12.610 12.610 ↑ 10.0 1 2,522

Index Scan using idx_qr001_hjgroupode_notnull on pr_kddi_hjfront_data_qr001 "ACCOUNT" (cost=0.42..44.01 rows=10 width=11) (actual time=0.003..0.005 rows=1 loops=2,522)

  • Index Cond: ((togoseikyusakiacc)::text = ("PC0".togoseikyusakiacc)::text)
  • Filter: ((companynum)::text <> '01496133D'::text)
  • Rows Removed by Filter: 0