explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yI6O

Settings
# exclusive inclusive rows x rows loops node
1. 0.114 85,183.594 ↑ 131.6 38 1

Sort (cost=339,655,607.58..339,655,620.09 rows=5,002 width=592) (actual time=85,183.566..85,183.594 rows=38 loops=1)

  • Sort Key: "PC0".hjwaribikigrcd, "PC0".tsushinwaribikigrcd, "PC0".togoseikyusakiacc, "PC0".onepaycd, "PC0".genrknplancd, "PC0".kanyushakanjinmnospace
  • Sort Method: quicksort Memory: 30kB
2. 28,884.934 85,183.480 ↑ 131.6 38 1

HashAggregate (cost=339,655,250.23..339,655,300.25 rows=5,002 width=592) (actual time=85,183.438..85,183.480 rows=38 loops=1)

  • Group Key: "PC0".hjwaribikigrcd, "PC0".tsushinwaribikigrcd, "PC0".togoseikyusakiacc, "PC0".onepaycd, "PC0".genrknplancd, "PC0".kanyushakanjinmnospace
3. 31,945.458 56,298.546 ↑ 405.7 25,599,778 1

Merge Right Join (cost=1,721,941.84..157,922,785.65 rows=10,384,712,262 width=593) (actual time=2,126.282..56,298.546 rows=25,599,778 loops=1)

  • Merge Cond: (("HJGROUP".hjwaribikigrcd)::text = ("PC0".hjwaribikigrcd)::text)
4. 8,941.637 8,941.637 ↑ 1.0 3,574,590 1

Index Only Scan using idx_qr001_hjcode_null on pr_kddi_hjfront_data_qr001 "HJGROUP" (cost=0.43..415,044.62 rows=3,622,272 width=9) (actual time=0.059..8,941.637 rows=3,574,590 loops=1)

  • Heap Fetches: 3,574,590
5. 13,361.482 15,411.451 ↓ 10.6 25,599,778 1

Materialize (cost=1,721,941.41..1,734,036.55 rows=2,419,029 width=593) (actual time=2,043.554..15,411.451 rows=25,599,778 loops=1)

6. 16.849 2,049.969 ↑ 227.4 10,640 1

Sort (cost=1,721,941.41..1,727,988.98 rows=2,419,029 width=593) (actual time=2,043.547..2,049.969 rows=10,640 loops=1)

  • Sort Key: "PC0".hjwaribikigrcd USING ~<~
  • Sort Method: quicksort Memory: 1,881kB
7. 217.187 2,033.120 ↑ 227.4 10,640 1

Merge Left Join (cost=138,433.78..175,617.80 rows=2,419,029 width=593) (actual time=1,193.312..2,033.120 rows=10,640 loops=1)

  • Merge Cond: (("PC0".togoseikyusakiacc)::text = ("ACCOUNT".togoseikyusakiacc)::text)
8. 7.463 33.948 ↑ 1.3 3,782 1

Sort (cost=16,167.86..16,180.43 rows=5,031 width=593) (actual time=31.553..33.948 rows=3,782 loops=1)

  • Sort Key: "PC0".togoseikyusakiacc
  • Sort Method: quicksort Memory: 629kB
9. 25.571 26.485 ↑ 1.3 3,782 1

Bitmap Heap Scan on pr_kddi_hjfront_data_qr001 "PC0" (cost=143.42..15,858.54 rows=5,031 width=593) (actual time=1.297..26.485 rows=3,782 loops=1)

  • Recheck Cond: ((companynum)::text = '01496133D'::text)
  • Heap Blocks: exact=2,462
10. 0.914 0.914 ↑ 1.3 3,783 1

Bitmap Index Scan on idx_qr001_comanynum (cost=0.00..142.16 rows=5,031 width=0) (actual time=0.914..0.914 rows=3,783 loops=1)

  • Index Cond: ((companynum)::text = '01496133D'::text)
11. 363.025 1,781.985 ↑ 1.0 348,956 1

Materialize (cost=122,265.93..124,012.79 rows=349,372 width=11) (actual time=1,153.362..1,781.985 rows=348,956 loops=1)

12. 706.003 1,418.960 ↑ 1.0 342,326 1

Sort (cost=122,265.93..123,139.36 rows=349,372 width=11) (actual time=1,153.357..1,418.960 rows=342,326 loops=1)

  • Sort Key: "ACCOUNT".togoseikyusakiacc
  • Sort Method: external merge Disk: 7,072kB
13. 652.210 712.957 ↑ 1.0 345,787 1

Bitmap Heap Scan on pr_kddi_hjfront_data_qr001 "ACCOUNT" (cost=8,732.82..84,127.54 rows=349,372 width=11) (actual time=76.692..712.957 rows=345,787 loops=1)

  • Recheck Cond: (hjwaribikigrcd IS NULL)
  • Heap Blocks: exact=57,850
14. 60.747 60.747 ↑ 1.0 345,962 1

Bitmap Index Scan on idx_qr001_hjcode_notnull (cost=0.00..8,645.48 rows=349,372 width=0) (actual time=60.747..60.747 rows=345,962 loops=1)